How to Delete "Compact on Close" in Access 2007

There are many features with Microsoft Office Access 2007 that can help you fix errors or issues you are experiencing either with the program or with a specific database file. For example, you can use the 'compact on close' feature to have your database file compacted every time you close Access 2007. However, with this feature turned on, it can take a while to exit the program. You can manually delete the 'compact on close' feature by disabling it in Access Options.

Instructions

1. Open the Microsoft Access 2007 application on your computer. Click the "Microsoft Office" button from the top-left corner of the program.

2. Click the "Access Options" button at the bottom of the screen. The Access Options dialog box will appear.

3. Click the "Current Database" option from the left side of the dialog box. Locate the "Application Options" section.

4. Click the box next to the "Compact on Close" field so that it becomes deselected. Close out of the Access Options dialog box.

5. Select the "Home" tab from the top of the page. Click "Save". Close out of the application. You notice the application is no longer compacted when you have closed the application.

References

• Microsoft Office; Help Prevent and Correct Database File Problems by Using Compact and Repair