Problems with VBA code on different computers

[Radu84]

Hello,

I've created a front end which has linked tables to the back end data which is on a network drive.

Basically until now, the front end has been lying on 2 computers, and it has been working as expected. When I installed the front end on a few other computers, I started getting errors because of my code. The versions of Access are identical ( right down to the same service pack, etc).
Could it be because in some parts of my code I havent declared some variables ( simply because i forgot about them, because the vba compiler didnt give me any errors, so they were probably declared automatically as variant type). But still the versions of Access are identical and the operating systems as well (I'm pretty sure).

Any sort of help would be most welcome.

 

[ghudson]

Check for missing references. Search around if you do not know what that means.

 

[Radu84]

Will look into it, thx

 

[Robert88]

Radu84

Have you got the network drives mapped the same on each client?

Robert88

 

[Summerwind]

I had a very similar problem once.

The problem was that the server was mapped to different drives on the front end machines.

That was when I learnt to use a global string as a connection string to the server! After re-writing code throughout app, changing the connection string for each front end machine was a cinch.

Are we developers masochists?