Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Corrupt Access 2013 Database

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

Access-VBA.PNG
Access-VBA2.PNG
I can neither backup the file or repair and compact it. What should I do?
0
John_Holecek
Asked:
John_Holecek
  • 3
  • 3
  • 2
  • +2
2 Solutions
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
I had a corruption in an Access 2013 database - only option was to revert to a backup.
0
 
John_HolecekAuthor Commented:
I don't have a current backup, so that's out.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Jeffrey CoachmanCommented:
can you try opening the file again in Access 2010?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
wayne_phillipsCommented:
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.
0
 
John_HolecekAuthor Commented:
I installed Access 2010 and opened the database. I got the error message, but I was able to do a compact and repair. I then opened the database in Access 2013, and there were no error messages.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are extremely lucky  this time.

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

mx
0
 
John_HolecekAuthor Commented:
It worked.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now