Iain M said:
No answer for you, sorry, but I think I am having similar
problems...
I constructed a database using Access 2000 on Win 98, but
it now doesn't work using Access 2000 on Win XP. It now
produces compile errors because it can't find functions as
simple as String() or Chr(). Can anyone help?
Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones, delete
from the references list and Compile and Save All. Keep any
necessary references and ensure they are distributed to the target
system.
For a very detailed page on reference problems see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.
The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm