Reduce97.mdb (expert)

Please consider donating $1 per sample downloaded, find out why here
Download
Reduce97.zip
Access 97 (388 KB)

This was originally designed as a way to delete large amounts of data from very large databases. The problem with using a delete query is that it tries to save all the deleted records in memory just so it can ask you if you are really sure at the end. I also needed a way to break into the delete without un-deleting the already deleted records (something else the delete query does not allow). I needed to delete hundreds of thousands of records, and delete queries were not working.

These functions delete the records through VBA. They open a recordset, move to the first record, delete it, and move to the next, and so on. The Simple form just selects records to delete based on only one date. The Advanced form allows you choose a range of dates and also exclude time ranges when the process will not work. By default, it will cancel execution at midnight.

Both forms allow you to break into the delete without un-deleting records. Once they are deleted, they are deleted for good. There is no recovery. That being the case, you should probably back up the table, so you have good data to work with. Click the button below to back up the table.

 

Feedback

 

Need Winzip?

Return to Main Page