Access 97 to Access 2000

[Phil Brewer]

Hi

I have an Access 97 database to convert to Access 2000. If
I do this on my local machine everything converts and
compiles fine. However, if I do this on a remote machine
there are compilation errors. Both PCs have Access 2000
(9.0.3821 SR-1) running on Windows 2000.
I assume there is a problem with a DLL somewhere but if
anyone can help it would be very much appreciated.
(If I converted/compiled locally would it then run on the
remote machine with no problems?)

Regards

Phil Brewer

 

[Allen Browne]

Press Ctrl+G to open the Immediate Window.
Choose References from the Tools menu.
Anything marked "MISSING"?

More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

 

[Phil Brewer]

Many thanks Allen

I assume that this should be checked on all PCs that are
going to use the new database? Is there any way of
producing a References list if the conversion does compile
correctly?

Regards

Phil Brewer

 

[Allen Browne]

If you keep your references to the minimum, the database should run on any
PC that has Office correctly installed.

If a reference is missing it is quite difficult to do *anything*
programmatically. Essentially you have to disambiguate every reference so
that VBA does not realize there is a missing reference, e.g. use VBA.Left()
instead of Left() in the startup code.

michka has more on this in his article:
How to guarantee that references will work in your applications
at:
http://www.trigeminal.com/usenet/usenet026.asp?1033