This error is caused by a difference of versions between libraries on the
first machine this application was run and the machine with Access 97. You
shouldn't copy a MDB file that have been used on another version of Windows
without first recompiling all your stuff.
Two methods of doing this:
1- create a link to the mdb file and add the parameter /decompile in it.
2- or add or remove a dummy reference in the References dialog window.
The fact that the list of references has changed will force Access to
recompile all modules. You can also choose to do a Recompile all modules
from the Debug menu (not sure here because A97 is an old version) to see
that there is no missing reference or error in the code.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Florin" <florin_serban[ at ]hotmail.com> wrote in message
news:%23cY6$NiiGHA.4776[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > Hi
>
> Why, on workstation, I get error messages 'Function isn't avaible in
> expressions in query expression Left(......)' ?
> On another workstation my aplication run without problems.
>
>
|