In today's Access Developer video, you will learn why deleting records inside a record set loop in Access VBA can cause serious problems, especially with SQL Server and ODBC connections. I will show you the safe way to check each record with your business rules, archive it, and then delete it, all without losing track of your records or skipping any. You will also see how to pass a record set into a function and use it for checking business logic, plus get tips on using transactions, logging, error handling, dry run mode, and some advice for multi-user databases. If you want to make sure your record deletes work smoothly, this lesson is a must see.