Recovering a Corrupt Access DB

Hi Experts,

A client asked me if I could recover a corrupt database, and I am looking for opinions how to go about it.

I believe that they were using Access 97, but when I try to open it in Access 2010, I get the following error messages, one after the other after clicking "OK". I do have access to Access 365 and 97, but I am wondering on how I can start, or if this is possible?

Thank you
Error-Messages.png
APD TorontoAsked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
1. Always make a backup of the bad database before you try anything because operating on the original can compound the problem.
2. This is a service I used for a client in a similar situation.  http://www.everythingaccess.com/accessdatabaserepair_info.asp
3. Make a backup plan and keep backups of both the FE and the BE.  FMSINC.com has a tool for sale that can be used to automate the process.
1
 
pc-cytCommented:
Hello,

Is it too obvious to say  "go to a backup" ?
0
 
APD TorontoAuthor Commented:
:)  Last working backup is in May.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
pc-cytConnect With a Mentor Commented:
Is this mdb the "whole" database or is this mdb one of many that make up the database?

I would look for 3rd party utilities  - I just made a search and found several that offer free trial and paid license is less an hour of labour.  That would be something to try while waiting for other responses.

There might even be some open source tools:  https://en.wikipedia.org/wiki/MDB_Tools
0
 
arnoldCommented:
Better May, than nothing. Adjusting to a more frequent backup would be the order of the day going forward.
The difficulty is trying to figure out what might have led to the corruption and when the corruption occurred.
nothing else is at issue i.e. the system where the file is experienced drive related corruption issues.

Try attaching a copy of the MDB file to an SQL server and see if that can ..

from the last page, seems an errand command deleted an object that is the cause of the corruption.
0
 
APD TorontoAuthor Commented:
I dont understand...

Try attaching a copy of the MDB file to an SQL server and see if that can ..

from the last page, seems an errand command deleted an object that is the cause of the corruption.

I will try Googling in the meanwhile.
0
 
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
maybe its best to try the 97 ...just fire a Windows XP VM and you will be good to go
0
 
arnoldConnect With a Mentor Commented:
trying to see whether MS sql will have a better set of tools to access the MDB file.
Trying to import the MDB.
Attempts already made to repair the DB may have compounded the issue.  


depending on what the data in it is like, do they have a way to access six months back worth of .....
0
 
Gustav BrockConnect With a Mentor CIOCommented:
I do have access to Access 365 and 97

Then use Access 97, as Access 2007+ cannot open the old JET 3.5 format which Access 97 uses.

/gustav
1
 
Fabrice LambertConnect With a Mentor Fabrice LambertCommented:
Did you check the file size ?
I hope it doesn't exceed 2GB.
0
 
Bharat BhushanSolution ManagerCommented:
Yes, the updated backup is the best way to get the data back. In your case, it is not updated so I will suggest you to use Access database repair tool to repair the file. Stellar Phoenix Access Database Repair software repairs the corrupt MDB and ACCDB files. It comes up with the demo version which, provides the preview facility.

Good Luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.