How to Compact MS Access Database
- George Apostolov
How to Compact MS Access Database: step-by-step guide
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.
Quick answer: To compact your MS Access database, ensure it is closed and select Options from the File menu. Next, click Current Database in the Access Options dialog, check the Compact on Close setting, and click OK to confirm your action.
About this tutorial
Shrink and optimize your database easily inside the app by enabling the compact on close setting in the options menu. This guide shows how to compact MS Access Database in 5 steps, starting with "Ensure the database you want to compact is closed. From the 'File' menu, select 'Options'" and finishing with "Click 'OK' to confirm the action". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to compact MS Access Database?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
