# How to Reduce MS Access Database Size

> To reduce the database size in Microsoft Access, go to Database Tools and select Compact and Repair Database. To compact the database each time it closes, click Options, select Current Database, check Compact on Close, and click OK to apply changes.

Canonical: https://livedemo.ai/tutorials/how-to-reduce-ms-access-database-size/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4bc4ab56e05a00ff72a0/preview?step=1

## Steps

1. Go to 'Database Tools'.
2. Select 'Compact and Repair Database'.
3. To compact the database each time it closes, click 'Options'.
4. Select 'Current Database'.
5. Check 'Compact on Close'.
6. Click 'OK' to apply changes.