VB expressions do not work properly in different installations of Access 97
A database I built uses, in both queries and modules, various
expressions. All of these work properly when I run the objects involved,
using Access 97 SR-2 on my workstation (which is also where I built the
database). However, another user has problems running these objects.
The main problem seems to be the use of string-functions (Mid, Left) and
lookups.We both use the same file (stored on a LAN), the same version of
Access and we both have the same privileges.
The error message when opening queries that uses, for instance, a
calculated field " Expr1: Left([Fieldname],2) " is as follows: "
Function isn't available in expressions in query expression
'Left([Fieldname],2)'
The same function in a VB module triggers a "Compile error: can't find
project or library".
The user having these problems in using my database, does not have them
in using his own databases.
A. de Vries
Trainee at Mannesmann Demag Delaval
Hengelo, The Netherlands
