Infero Training – Business and Technical Courses

To ensure optimal performance of your Access database, you can run the Compact and Repair utility within Access. This utility rearranges how the database is stored on a disk if the database is fragmented.

To set an option that automates this process every time the database is closed:

1. Open the Access database that you want Access to compact automatically.
2. Click the Office Button , and then click Access Options.
3. Click Current Database and, from Application Options, select the Compact on Close check box.