Large database files can quickly impact performance or even become corrupted or damaged. Using the Compact and Repair Database command in Microsoft Office Access we can often prevent or fix these problems. While it is possible to manually use this command occasionally, it is good practice to automatically compact and repair a database when it closes as per the following steps.
- On the “File” tab, click “Options”.
- Click the “Current Database” tab.
- Under “Application Options”, select the “Compact on Close” check box.
Be aware that setting this option will only affect the database that is currently open. You must set this option separately for each database that you want to automatically compact and repair.