(Q) My Access 97 database runs fine on some pcs, but on one particular machine, I keep
getting errors like "Undefined Function" or "Function not available in
query expressions". Upon hitting Debug, one of the following functions are
Left$, Right$, Mid$, Instr, Trim, Str (etc)
What's causing this error to happen on individual machines?
(A) This is a common problem that users might face whenever they upgrade from Office 95
to Office 97. Sometimes, Access loses references to libraries containing the definitions
to above and other functions, giving you the error message.
Open a module go to Tools/references, check the list of references and find the one
that is marked missing, you will probably find that the file the reference requires is
either not on the machine or not registered (if it is an OCX/DLL/Exe etc) or is in the
wrong place (an Access Library database for example).
The important things are:
1) identify the missing reference
2) remove it from the references
3) re-establish the reference if it is required by
Pointing at the correct file (using) browse)
Putting the file on the target machine (and
register it if required)
Register it if it is present
You can also download the References Wizard which will
help you in sorting out this problem.