Solved How to fix corruption error in Microsoft Access database

Microsoft Office 2010 professional (full...
August 24, 2015 at 04:31:50
Specs: Windows 7, i3
I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact & Repair, but when I get the same error message when I try that. If I open a blank database & try to import objects from the corrupted database, I cannot access/view the objects of the corrupted file from the blank database. Unfortunately, I dont have a backup of the file, I can try to restore to an earlier storage point (using System Restore), but will lose considerable work. Any ideas?

See More: How to fix corruption error in Microsoft Access database

Report •

August 24, 2015 at 04:48:56
It is sometimes a good idea to decompile your database and then compacting and repairing. I had a similar issue just the other week, my database kept of throwing an error "File not found" however i have no code within my DB that searching or references ANY file. I just decompiled the code and it all worked again..

Create a shortcut and enter the below into the taget, you can also copy paste a shortcut and edit the target to the below. You will need the path to where MS ACCESS is installed and the path to where you database is stored.

Then run the shortcut and it should decompile your database. Once you've sucessfully done that, compact and repair it again.

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "c:\YourDatabaseName.mdb" /decompile

message edited by AlwaysWillingToLearn

Report •

August 28, 2015 at 04:45:31
✔ Best Answer
As far as my knowledge & experience is concerned, you can convert 2003 format to 2007, but not backwards, i.e. 2007 cannot be converted back to 2003. Please explain if I am missing something.


Report •
Related Solutions

Ask Question