Same code don't run

[Copierbw]

We had a Access 97 database which we converted to Access 2002 version. We had to fix the odd conversion problem manually. The problem I have now is that we made those changes and tested them on a copied version of the live database. The code worked 100% but when we changed the code in the live database to reflect exactly the same as with the copied version we get errors in the live version. I've compared the code line for line and it exactly the same. The only difference, the copied version was run, tested on my local XP-Workstation and the live database resides on a W2K server. How can that be? Anyone have a explanation for this or what might have gone wrong? Thanks

 

[KenReay]

Hi

What are the errors?

Most likely reason is that versions of Run Time libraries are different on the two machines, and that you are getting missibing reference problems.

If this is so you will get error message9s) when you try to open the database Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Copierbw]

The database opens up normally but when I click on one of the buttons on a form I get "Variable not defined". This worked without any error on the local copied version but once I changed the live version code and access it through the network I get this error.

 

[KenReay]

Hi

Have you tried the Compile option on the 'live' database, then correct any errors found Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK