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

About the Repair and Compact Tool

About the Database Files

Repairing Damaged Database Files