How to Compact MS Access Database
Compacting a Microsoft Access database is an important maintenance task that helps reduce the file size and optimize the performance of your database. Here’s how to do it:
- Ensure the database you want to compact is closed. From the 'File' menu, select 'Options'.
- In the 'Access Options' dialog, click on 'Current Database' in the left pane.
- Scroll down to the 'Compact on Close' setting and click on it.
- Click 'OK'.
- Click 'OK' to confirm the action.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it