Access 97 and 2000 on same computer

R

Roy

hi

i put 97 and 2002 on the same computer, they are on diferent folders.
they work fine until i use some nz fuctions in 2002, and it comes up with
"#NAME?".
if i use the database only with 2002 install, it works fine. any ideias

thanks
 
A

Allen Browne

Yes, you can run multiple versions of Access on the one computer. The one I
am posting from has Access 2, 97, 2000, 2002, and 2003.

First, check your references.
From any code window, choose References on the Tools menu.
Anything marked 'MISSING'?
More info:
http://allenbrowne.com/ser-38.html

Post back if that is not the issue.

More info on setup and conversion issues between Access 97 to 2002, see:
Converting from Access 97 to 2000, 2002 or 2003
at:
http://allenbrowne.com/ser-48.html
 
R

Roy

There is nothing missing.
do you know what reference to add on to work with the nz fuction??
thanks
 
A

Allen Browne

Nz() is part of the Access library.
You can't uncheck that, but if any other library is missing, it won't work.

Try this:
1. Write down the name of all libraries that are checked.
2. Uncheck them all except the Access and VBA libraries (which are
required.)
3. Close Access, and restart it.
4. Find the libraries that were checked, and check them again.

You may even need to re-register the library between steps 3 and 4. The
article referenced in the previous reply shows you how to do that, and
indicates which libraries you should use with each version.

Note that you should be using DAO 3.51 with Access 97, but DAO 3.6 with
Access 2002.
 
Top