How to Repair the Database in Access 2007 Compact
- 1). Open the Microsoft Access 2007 application and then click the "Microsoft Office" button from the top left corner of the program.
- 2). Click the "Open" option and select the database you want to repair from the dialog box that appears. Click the "Open" button.
- 3). Move your mouse over the "Manage" option and then click the "Compact and Repair Database" option. Your database will then be automatically compacted and repaired.
- 4). Click the "Microsoft Office" button again if you are having problems opening your database. Move your mouse over the "Manage" option and then click the "Compact and Repair Database" option.
- 5). Double-click the database you want to be repaired from the "Database to Compact From" dialog box. The database you had trouble opening will then be fully compacted and repaired.
Source...