Left Function is not available in expressions in query expression (Access 2000)
Posted on 2002-06-24
This is recently occuring in some offsite computers using a variety of operating systems (95, 98, 2000, and possibly XP).
The Access 2000 database contains a query that uses the Left() function and recieving the error:
"Function is not available in expressions in query expression 'Left(.." etc.
From the information I have gathered about this problem so far, I believe from what I read, please someone correct me if I am wrong.. that.. the development computer is using an earlier version of the .dll that contains the Left() function while the user computers off-site have gotten ahold of a newer version of this same .dll.
I have not been able to locate which .dll file contains the function Left(). Does anyone know which .dll it is? Maybe I can get a good start from there of how to tackle this problem and work from there.
I have found an article and a solution that involved refreshing the references. This will not work in this instance due to the non-dev databases being .mde.
Thank you for any possible help,