APD Toronto
asked on
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
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
ASKER
:) Last working backup is in May.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
I dont understand...
I will try Googling in the meanwhile.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
Good Luck!
Is it too obvious to say "go to a backup" ?