Databases tend to grow with use and can become corrupted. Using the Compact and Repair Database command assists in preventing and correcting problems that can affect a database.
- Make sure that you are the only one in the database. Only one user can be in the database for this tool to run.
- Select the Microsoft Office button.
- From the Office menu, select 'Manage'.
- Select 'Compact and Repair'.
- The 'Database to Compact From' dialog box appears. Select the database that you wish to compact and repair.
- Select the Compact button.
- Rename the compacted database in the 'Compact Database Into' dialog box.
- Select the Save button.
- Optional: After checking that the compacted database is running properly, you can delete the older version and rename the newer version the same as the old database.