Access: Compress database - how it works
The longer you use Microsoft Access, the larger your databases will be. You should therefore compress the data regularly. We explain how this works in this practical tip.
How to compress your Access database
Over time, your Access databases fill up with large amounts of data. Among other things, this is due to deleted data, which Access does not completely remove, but only hides it. To permanently delete this data, you must compress the database:
- Open your database with Microsoft Access.
- Then select the "Database tools" tab at the top.
- Click the "Compact and repair database" button on the left. Access then shrinks your database.
If you also want to save space optically, you can combine individual Access tables. This article is based on Microsoft Access 2013 and Windows 8.1.