Quick summary
The Compact and Repair tool in MS Access reduces database file size by reclaiming unused space left behind after deletions and updates. You can also enable Compact on Close to automatically optimize your database every time it shuts down.
Steps
- Go to Database Tools in the MS Access ribbon.
- Select Compact and Repair Database to immediately reduce the database file size.
- To enable automatic compacting, click Options in the File menu.
- Select Current Database from the left-hand navigation panel.
- Check the Compact on Close option to automatically compact the database each time it closes.
- Click OK to apply and save your changes.
