Compact an Access 2007 database

 

Question:  How do I compact and/or repair an Access 2007 database?

 

Answer:  Click the Office Button (top left) to display the main menu.
Choose Manage and then Compact and Repair Database.

 

It is also possible to set the database to Compact each time it closes. To do this:
Click the Office Button (top left) to display the main menu.
Choose Current Database and ensure Compact on Close is ticked.

 

Applies to: Microsoft Access 2007