100 Library Drive
Rochester, MI 48309-4479
(248) 370-4357 (HELP)
Fax: (248) 370-4863
Office Hours: M-F 8:00am - 5:00pm
Classroom support hours:
Monday-Thursday 7:30 a.m. - 8 p.m.
Friday 7:30 a.m. - 6 p.m.
Saturday 8 a.m. - 5 p.m.
How do I Repair a Corrupted Access Database?
How Do I Repair a Corrupted Access Database
Occasionally, a Microsoft Access database might encounter corruption. This could happen if there are any interruptions to Access while it is working on the database. While database recovery is sometimes impossible, there are some steps you can take to try and recover your data.
Step 1: This process uses the repair feature in Microsoft Access 2010.
- Start Microsoft Access
- Click on the Database Tools tab, select Compact and Repair Database
- A Database to Compact From dialog box should appear. Locate your corrupt database and click on the Compact button to continue.
- A Contact Database Into dialog box should appear. Type in a new name for your database and click Save to continue.
The database should attempt to repair itself. When it is done, click on the File menu, select Open, and open up the database that was just created.
If you are still experiencing problems opening up the database, please proceed to Step 2 below. Otherwise, you are finished.
Step 2: This process attempts to create a new file, and import the data from the corrupted database.
- Start Microsoft Access.
- Select Blank Access Database and click OK.
- Give a name to your new database and choose a file location, and click Create.
- Click on the File menu, go to Get External Data, and select Import.
- Locate and select your corrupted database, and click Import.
- If you DO NOT receive an Import Objects window, than this process cannot recover your Access database. Otherwise, continue.
- Click on the Tables tab at the top of the Import Objects window, and click Select All. Repeat for the other 6 tabs in the window, and click the OK button when done.
If the tables were linked to Banner, you will need to enter your Banner password.
When complete, the data from the corrupt database should now be in the file that was just created.