File server databases like Access/JET MDB and ACCDB files need to be periodically compacted and repaired for optimal performance and to minimize database corruption. Compacting also eliminates database bloat that can occur as data is added and deleted in the database. Here's a Microsoft Knowledgebase article that discusses some of the issues.
Microsoft Access databases can be manually compacted from the Access menu. Over the last few versions of Access, the location of this command has moved around. Here's a summary across versions of compacting the currently opened database or another database.
If you have a database open, the Compact and Repair Database command will compact it. If a database is not open, it will prompt you to select a database on disk and the name of the compacted database. You can select the option from the Database Tools ribbon:
It is also available on the File Menu. Choose Info, then select the Compact & Repair Database button on the right:
Similarly, the Compact and Repair Database option is on the Database Tools ribbon:
It is also available on the File Menu, under Info. Select the Compact & Repair Database button on the right:
Microsoft Access 2007 does not have a Compact option from the Database Tools ribbon. To compact in Access 2007, from the Office button, select Manage and choose Compact and Repair Database:
Pre-ribbon, it was simply on the menu under: Tools, Database Utilities, Compact and Repair Database
Total Visual Agent manages an unlimited number of databases across your network and schedule database chores in the middle of the night. Perform compact, backups, data extracts, running macros, command lines, and other tasks. Schedule events hourly, daily, weekly, monthly or just one time. Complete audit trail with email notification if anything goes wrong. Try the Free Trial today!
Total Access Admin lets you monitor Access databases in real-time to see who's currently in it and when they leave. It flags users who disconnect in a suspect manner which may indicate a source of database corruption. It can also perform tasks after everyone has exited such as compact. Try the Free Trial today!
With Windows Service!
Supports: All Access, Jet Engine, and Visual Basic versions
"Total Visual Agent is a real find, a rare combination of ease of use, and bang for the buck. In the end, no other competitor even comes close."
Thomas Wagner, Product Review in MS Office and VBA Developer