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 TorontoSoftware DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chief AvocadoChief of Problem Avocado'sCommented:
Hello,

Is it too obvious to say  "go to a backup" ?
0
APD TorontoSoftware DeveloperAuthor Commented:
:)  Last working backup is in May.
0
Chief AvocadoChief of Problem Avocado'sCommented:
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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 TorontoSoftware DeveloperAuthor 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 TsioumprisSoftware & Systems EngineerCommented:
maybe its best to try the 97 ...just fire a Windows XP VM and you will be good to go
0
arnoldCommented:
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 BrockCIOCommented:
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 LambertFabrice LambertCommented:
Did you check the file size ?
I hope it doesn't exceed 2GB.
0
PatHartmanCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.