.svg){kind=icon}
.gif)
.svg)
Here's how to achieve this:
- Go to 'Database Tools'.
- Select 'Compact and Repair Database'.
- To compact the database each time it closes, click 'Options'.
- Select 'Current Database'.
- Check 'Compact on Close'.
- Click 'OK' to apply changes.
How to Reduce MS Access Database Size
Use this interactive demo to learn how to reduce the size of your MS Access database.
📌 Why this matters
Large Access databases drain system performance and make backups painfully slow. More critically, databases approaching the 2GB file size limit become unstable and risk corruption. Regular compacting removes deleted record fragments that accumulate invisibly over time, often shrinking files by 30-50%.
Setting automatic compaction prevents you from hitting size walls during critical work periods. Since Access stores everything in a single file, bloat affects every operation from queries to reports, making this maintenance essential for reliable long-term database performance.
Your product deserves an interactive demo
Similar Articles
No items found.