the database cannot be open because the VBA project cannot be read.

[Andy74]

Hello everybody,

this morning I had to run our accde project (used in our company in about 40 stations) on a new pc. It has Windows 7 SP1 and I installed Access Runtime 2013. The accde has been compiled on Access 2010 on my laptop.
I got the above message and cannot find the solution and then the application crushes. I remember we had a similar issue in February this year as a consequence of a Windows update which caused the problem extensively.

If anybody can help I would appreciate.

Andy

 

[Ranman256]

Does it open in native Access?
If so, try opening it in runtime on a different OS.
Or a different runtime version. (Older)

I had this happen too.

 

[CJ_London]

if you've compiled in 2010, you need to use 2010 runtime. Alternatively try opening a .accdb version with 2013 runtime.

Other thing to consider is 32bit/64bit office - they don't mix unless you have coded to allow for it. So if you've compiled on 32bit and new user has 64bit office.....

 

[Andy74]

I have tried also Access 2010 runtime but it gives the same as Access 2013 runtime.

The accdb file has been opened without problems even in Runtime 2013, the problem lies in the accde.

The PC doesn't have native Access so I cannot check if it opens the accdb with native Access!

Andy

 

[CJ_London]

presume you've decompiled the db, have option explicit at the top of all modules, recompiled successfully and remade the .accde? And that the .accde runs OK on your machine?

With regards checking whether runtime has opened a .accdb successfully, check for the locking file