Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. This risk increases for databases shared by multiple users over a network. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.
Time Required: 20 minutes
- Instruct other users to close the database. You must be the only user with the database open in order to run the tool.
- Click the Microsoft Office button.
- From the Office menu, choose "Manage", then "Compact and Repair Database"
- Access will present the "Database to Compact From" dialog box. Navigate to the database you wish to compact and repair and then click the Compact button.
- Provide a new name for the compacted database in the "Compact Database Into" dialog box, then click the Save button.
- After verifying that the compacted database works properly, delete the original database and rename the compacted database with the original database's name. (This step is optional.)
- Remember that compact and repair creates a new database file. Therefore, any NTFS file permissions you applied to the original database will not apply to the compacted database. It's best to use user-level security instead of NTFS permissions for this reason.
What You Need
- Microsoft Office Access 2007