AimoSala Posted May 16, 2016 Share Posted May 16, 2016 Hello, I have a database .mdb which has got corrupted (Error 3197). I can't open it. I have tried and searched any solution, but apparently there is no one. Can somebody help me, please? By the way, I found this solution in EE and even tried AccessRecovery 2.1, but no success. MS Access database recovery steps: 1) Create a backup of the corrupt database. (Just in case of) 2) Create a new database and use File/Get external data/Import to get all objects of the damaged database. 3) Try these Microsoft solutions: Repair A97/A2000:http://support.microsoft.com/support/kb/articles/Q109/9/53.aspJetcomp:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956and/or read the article: ACC2000: How to Troubleshoot Corruption in a Microsoft Access Databasehttp://support.microsoft.com/default.aspx?scid=kb;en-us;3062044) Bit "heavier": Access decompile:http://www.granite.ab.ca/access/decompile.htm 1 Quote Link to comment Share on other sites More sharing options...
danielsson Posted May 23, 2016 Share Posted May 23, 2016 - make backup copy of your database. - Start a blank database, - Import all there is from bad.mdb to this blank database. Note: The process may stop while importing certain form or report. Take note of this object. Try it again but this time avoid importing that particual object. - Import the bad object from a recent copy, (at this point, it may allow you to import the bad object you were avoiding. try importing it. If you were able to import it, it will be called say frmCustomer1 because frmCustomer existed befor hand. Rename frmCustomer as frmCustomer2 and also rename frmCustomer1 bad one as frmCustomer). - Regardless the outcome of last step, try to compact and repair it. - Delete frmCustomer3 later after taking care of the problem. Just in case look this post. http://www.sqlservercentral.com/Forums/Topic1621376-384-1.aspx If your tried decompile and it still won’t work, u are pretty much screwed hate to say it. hope you have a recent backup. I don't know, but maybe you somehow will be able to help this program to save your data. http://www.oemailrecovery.com/access_repair.html Occasionally access db's get hopelessly corrupted for no apparent reason. This is why I back up may db about 5 times a day when I am coding. 1 Quote Link to comment Share on other sites More sharing options...
AimoSala Posted May 27, 2016 Author Share Posted May 27, 2016 You've been very kind in your efforts to help. Thanks for that. Solved! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.