Technology Training Community

Are you having difficulties finding the Compact and Repair feature in Microsoft Access 2007? In Access 2003, you found this feature in the tools menu by selecting Database Utilities. In Access 2007, you will find the Compact and Repair Database feature by selecting Manage, located under the Office Button. You can also have your database compact and repair itself every time it is closed, by activating the Compact on Close option. If you would like to set this option, you can find it in the Access Options for the Current Database.