How to Repair Access Data

A corrupted Microsoft Access database file can sometimes occur after the file has been published. This is likely to happen when the network crashes while a user is editing a database. An accumulation of normal events can also lead to database damage. For example, adding data slows down its retrieval as the file grows larger. Also, when an entry is deleted, leftover bits of the removed data still remain. By using the Compact and Repair Database command, you can remove unused space, fix what can be repaired and gain faster data retrieval.

Repair an Open Access Database Upon Closing It

• 1

  Click "Save & Publish" on the "File" tab. (Note: If the database you want to repair is not open, go to the next section.)

• 2

  Click "Back Up Database" under "Advanced."

• 3

  Click "Options" on the "File" tab.

• 4

  Click "Current Database" in the Access Options dialog box.

• 5

  Check the "Compact on Close" box under "Application Options" and then close out of the database.

Repair a Database Without Opening It

• 1

  Start Microsoft Office Access.

• 2

  Point to "Info" on the "File" tab using your mouse.

• 3

  Click "Compact and Repair Database."

• 4

  Double-click the database that you want to repair.