Recovering a Corrupt Access DB

APD Toronto
APD Toronto used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chief AvocadoChief of Problem Avocado's

Commented:
Hello,

Is it too obvious to say  "go to a backup" ?
APD TorontoSoftware Developer

Author

Commented:
:)  Last working backup is in May.
Chief AvocadoChief of Problem Avocado's
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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Distinguished Expert 2017

Commented:
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.
APD TorontoSoftware Developer

Author

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.
John TsioumprisSoftware & Systems Engineer
Commented:
maybe its best to try the 97 ...just fire a Windows XP VM and you will be good to go
Distinguished Expert 2017
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 .....
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
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
Fabrice LambertConsulting
Distinguished Expert 2017
Commented:
Did you check the file size ?
I hope it doesn't exceed 2GB.
Distinguished Expert 2017
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.
Bharat BhushanSolution Manager

Commented:
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial