Microsoft Office Tutorials and References
In Depth Information
Managing a Database
Compacting a database
When you compact a database, Access repairs the database at the same time. In many
cases, Access detects that a database is damaged when you try to open it and gives you
the option to compact and repair it at that time. For example, the data in your database
might become damaged, or corrupted, if you exit the Access program suddenly by
turning off your computer. If you think your database might be damaged because it is
behaving unpredictably, you can use the Compact & Repair Database option to ﬁ x it.
Compacting and Repairing a Database
• Make sure the database file you want to compact and repair is open.
• Click the File tab to display Backstage view.
• Make sure the Info tab is selected in the navigation bar.
• Click the Compact & Repair Database button.
Access also allows you to set an option to compact and repair a database ﬁ le
automatically every time you close it. The Compact on Close option is available in the
Current Database section of the Access Options dialog box, which you open from
Backstage view by clicking the Options command in the navigation bar. By default, the
Compact on Close option is turned off.
Next, you’ll compact the Belmont database manually using the Compact & Repair
Database option. This will make the database smaller and cause it to use disk space
more efﬁ ciently. After compacting the database, you’ll close it.
To compact and repair the Belmont database:
1. Click the File tab on the Ribbon to display Backstage view. The Info tab in the
navigation bar is selected.
Trouble? Check with your instructor before selecting the option to compact and
repair the database. If your instructor tells you not to select this option, click the
Exit command in the navigation bar and skip the next two steps.