Link to home
Start Free TrialLog in
Avatar of John_Holecek
John_HolecekFlag for United States of America

asked on

Corrupt Access 2013 Database

I created a database in Access 2010, upgraded to Office 2013 and am now getting the following error messages.

User generated image
User generated image
I can neither backup the file or repair and compact it. What should I do?
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

I had a corruption in an Access 2013 database - only option was to revert to a backup.
Avatar of John_Holecek

ASKER

I don't have a current backup, so that's out.
It quite simply may not be recoverable.  Backups are essential.  What OS are you using?  Perhaps System Restore can recover a prior version - look at the folder it was in and look for a Previous Versions tab.
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"I don't have a current backup, so that's out."
" What should I do?"

That error message means your db his hosed - a technical word for messed up - corrupted.

Your only hope at this point at this point it to send the file to Wayne @ http://www.everythingaccess.com/accessdatabaserepair_info.asp

If anyone can fix it, it will be Wayne.

Good luck.
btw ...  it takes less that literally two seconds to instantly backup any Access database in Windows Explorer:

Highlight the db, then Control C, Control  V. Done. Instant copy.  
OR
Highlight the db, left click and hold with your mouse and drag.  Instant copy.

I do this countless times per day when work on a give db - simply because s**t happens, as you can see.

mx
Avatar of wayne_phillips
wayne_phillips

With that particular message, if you then proceed to do a 'compact & repair', chances of recovering the VBA project are very slim.  

If you haven't done a compact & repair (or you have a backup before trying the compact & repair), then there is a good chance of us at EverythingAccess.com being able to recover the VBA project, using a very specialist technique.  If you want to get in touch, use the contact us link on EverythingAccess.com for the email address -- this will ensure your file gets the manual attention it needs.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You are extremely lucky  this time.

Please ... make frequent backups from this point on :-)

mx
It worked.