Compacting Database Files
Compacting optimizes the performance of Microsoft Access databases and can help prevent data corruption. If you make frequent changes in a database, parts of the database may become fragmented. We strongly recommend that you periodically repair and compact your databases.
To compact database files:
1 In the Project list, click a project.
2 In the Tools menu, click Repair and Compact.
3 In the Repair and Compact dialog, select the database files you want to compact.
Note that you cannot repair and compact SQL Server databases with this tool.
Related Topics