Access 2007-2010 "Database cannot be opened because the VBA project contained in it cannot be read" error

Question

I have Access 2010 installed on my machine and made a couple of updates to a copied version of a split frontend Access file. I renamed the updated copy to replace the original Access file and placed the old file in a backups folder. I needed to make another update the next day but was using a VPN connection that made accessing the frontend file a pain, so I remoted into a server that hosts the file and used that server's Access 2007 application to make the update to a copied version of the current file. I renamed the copy and placed the copy in the backups folder. The file version is 2007-2010 therefore I did not think that it was going to cause any errors to update. However, it did and I am not sure why.

When making these updates I never updated any VBA or received any kind of error apart from a SQL function error. The frontend was saved and compacted & repaired successfully each time. Then my end users started receiving macro and VBA errors that prevented them from opening the file or entering any information. I discovered that the VBA modules were completely deleted from the file. Additionally, every single backup and copies of the original backup were becoming corrupted every time I opened the file on my own computer using Access 2010, even if I did not hit OK to proceed to delete VBA modules. I could not open a single file without receiving the VBA error. The users access the frontend file by downloading their own copy on an intranet site, so they don't corrupt the actual file. When I tried doing this as well the file was still corrupted and it even corrupted the original file as well. My coworker was able to find a clean backup and the end users were able to resume work, but I cannot touch the file or else it will be corrupted too. Even if I SHIFT + Open to skip the start code, I still receive errors. My coworker is running Access 2013 and does not receive any of these errors when opening copies of the backup file, but they do receive the errors after I open a file.

I have tried:

• Compact & Repair
• Decompile/Recompile
• Access 2010 version is 14.0.7224.5000 (32-bit), so Office 2010 SP2 is already downloaded

The decompile did not work because I would immediately receive the VBA error upon opening the file (SHIFT + OPEN as well). I have no new Access updates to download. I cannot revert to a previous build as that is not a solution my company is okay with. I have not tried importing objects into a new frontend file because I cannot import or export the VBA modules due to them always being deleted or corrupted whenever I open a file. I would lose all of the VBA modules and since I am not the original developer I have no idea what was included. I am in the process of trying to update Access to 2013, but that may take a while.

Everything I have read about this issue says that this happens when different versions of Access try to open the same file, but if I was using Access 2007 and 2010 to open a file whose version was 2007-2010, why would I still get that error? If it was an issue with 2007, why do I corrupt every single backup file made before using the 2007 software while using 2010 as well, especially if others are able to access that file just fine while using 2010, 2013, and 2016?

I need some help trying to figure out why all of the Access files are breaking when I touch them all of a sudden. I have checked my implemented updates from the past few days and have not noticed anything specifically relating to Access or Microsoft Office. Should I reinstall Access 2010? Should I update to 2013 or is having a newer version going to cause the same issues anyway?

Answer 1

Hello Microsoft User

Microsoft Support number :- +1 (855) 921 1222

We have just found your issue we are very sorry for the inconvenience happen while using the Microsoft Product.

We have registered your request, please call our toll free so that we can assist you better

Microsoft Support number : - +1 (855) 921 1222

Use support link: https://goo.gl/forms/XZ6qr5gwwKVLXAgC3

Thank you For Using Microsoft Community Forum

Sandy Martin

(Microsoft Customer Help Desk)