1

We have an issue with MS Access 2010 (32-bit) that has left us scratching our heads. One of our users is responsible for developing and updating an access database application. Before distributing the front-end application, he compiles it as a .accde file. Three other users who use this application have had their desktop computer replaced. Since the upgrade, two of them are unable to open the .accde file compiled from the developer’s computer and get the error “unable to read VBA project”.

The strange part is that their new computers are now the exact same model as the developer’s workstation and the same image of windows (a comparison in spiceworks shows these computers as nearly identical). If the .accdb file is compiled to a .accde file it will also work perfectly. The application only fails to open if is compiled on the developers computer and then opened on one of these two ‘problem’ computers, all other computers can run this application.

Our developer is taking this issue to microsoft forums, but I thought I would post it here as well.

Anyone have any idea why MS Access would have a problem loading a .accde generated on another computer with the same hardware, version of windows, and version of office? Also, if it matters, these frontend applications are connecting to a MSSQL database (I’ve already check the ODBC connection, which is working correctly).

Thank you for any help you can provide,

Charles

1 Spice up
2

My initial thought is whether the Trusts are the same. I have had trouble where my Trust Zones weren’t set up the same. With new systems, did you set the trust zones up?

3

Yup, trusted zones are set up (deployed through Group Policy).

4

Do the new machines have a full copy of Access installed? If not, is the runtime installed properly?

5

The Computers are running the full version of Access.

6

Could it be an issue of some computers having Access SP1 and others not?

See : Microsoft Support

7

You know, when I looked at the machines I checked to make sure it had all windows updates installed, but maybe it didn’t pick up a service pack for office on one of them. When I get a chance to work on their computers I will take a look at the installed service packs.