MS Access 2007 DB, maintenance, compact and repair many DB's at once
Posted on 2013-01-22
I have a simple inventory DB I work with, only about 8,500 records. I have been using it a few years and recently realized I had not compacted and repaired in a long time, the DB was 35 MB and after compacting and repairing it is 2.5 MB.
I keep numerous back ups of the DB, pretty much every time any amount of data is entered or changed I back it up and leave these files in place. I have about 95 backups of the DB at several different dates and times over the years.
1. I made the change to allow it to compact on close. How often should I run compact and repair. Are there any other maintenance things I need to do for a MS Access DB to keep it up to snuff and running smooth?
2. Is there a way to bulk compact or bulk compact and repair all 95 backup DB files so it doesn't take up so much space?
Thanks for your help.