PROBLEM:
Some users of an ACCDE file get this error message:
"The database cannot be opened because the VBA project contained in it cannot be read."
Here are the details of what I'm doing:
1. I Make ACCDE from MS Access 2010
2. I put ACCDE on the network
3. Users try to load the ACCDE.
4. Some users are successful.
5. Some users get this message:
"The database cannot be opened because the VBA project contained in it cannot be read."
All users have the same install procedure:
1. Project Referenced DLLs
2. MS Access 2010 Runtime
Notes:
1. The ACCDB file opens and runs properly in Access Development Environment.
2. The ACCDE worked at some point on the user's machine that it now not working.
3. Some of the previous versions now do not work either.
4. We have tried decompiling , compact and repair, and starting a new DB and copying the objects in.
SOLUTION:
You have compiled the MS Access application with a version that is higher than the one used by the person trying to open the ACCDE file.
This could be as simple as compiling with MS Office 14.0.7151.5001 and the users getting the error is running 14.0.4760.1000. Onece the user is updated to 14.0.7151.5001 then the applicatioin will work again.
https://support.microsoft.com/en-us/kb/2533794