Microsoft Access databases have a habit of ballooning in size when a lot of deletes are done to a table.
On a regular basis, you will want to compact and repair the database. When a record is deleted from a table, the space is still marked as being used. The compact process simply releases the space back to the operating system. The repair process is a preventative measure mostly, and doesn't necessarily need to be done. Access databases are prone to corruption if they get too large or are used extensively in a multi-user environment. If there are problems opening the database or viewing the data, the repair process may be able to repair the corruption to the database file.
If you have Microsoft Access:
- Open the database in Access.
- Click on "Tools"
- Click on "Database Utilities"
- If you have Access 2000, click on "Compact and Repair Database..."
- If you have a version prior to 2000, the Compact and Repair are two separate options
If you do not have Microsoft Access:
- Open the Visual Data Designer.
- Click on "File"
- Click on "Compact MDB..."
- Click on "7.0 MDB..."
- Select the database to compact
- Click on "Open"
- Select the database again
- Click on "Save"
- You will be prompted to replace the database.
- Click on "Yes"
- You will be prompted to encrypt the database.
- Click on "No"
- You will be prompted to open the database.
- Click "yes" if you wish to work on the database.