The database cannot be opened because the VBA project contained in it cannot be read

[CHSBK]

Hi there

I have created a split database (back end is on a shared network drive and front end is on users' PCs) and it seems to work well on all but one of the PCs, where the user gets the following error:

The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted...

The user has local administration rights on the PC, the front end database is located in a trusted location and there does not seem to be any missing references.

We are using Access 2007 on Windows XP Professional.

Any help on resolving this issue would be very much appreciated.

Many thanks.

 

[BrettM]

Where is the shared network drive located?
Does the user have rights established on the shared network drive?
Is the Open Mode for the BE exclusive or shared?
Are you using Workgroup adminstration... is the user a member of the workgroup?

 

[CHSBK]

Hi BrettM

Thank you for your assistance

The network share is on one of our Windows fileservers, we have a client/server network set-up. All of our PCs have the same mapped drive to the network share and all users have the same the security/access rights in the shared drive. The BE database has a default open mode of shared.

Many thanks again for any assistance you can offer.

 

[DCrake]

If the user who is experiencing issues logs onto another pc that you know works and loads up the application does it still work or not. If not then this indicates that the source of the problem is the users profile. Conversley can a user who works on a pc that is allright log on to the offending pc and load the application sucsessfully? If not then this indicates that it is the pc that is generating the error. It's a case of trial and elimination.

David

 

[CHSBK]

Hi David

We do not use roaming profiles, so if we log on to each others PCs, we don't see anything. Perhaps this points to an issue on the other users PC? I just can't see what it is.

We are both members of the local administrators group on our PCs, albeit that I have been set up as a user via the 'Add Users' option in Control Panel, whereas my colleague was set up as a user via the 'Manage' option then 'Local Users & Groups' in My Computer. I cannot see that this should make any difference, however!!

Any further suggestions are most welcome.

 

[CHSBK]

Hi

I think I have found a resolution to the problem in that I created a new blank database and imported the tables from the BE and the Forms, VBA, Reports, etc. from the FE database. I then split this new database and (so far) everyone seems to be able to access it. I still don't know why the original problem arose, but, no doubt, when I need to make a change to the front end again, the problem will re-appear!!

Many thanks.

 

[michaelbro]

Does anyone know the cause of this problem ?