I am using Microsoft Access 2003 on Windows XP. I have a database that has just recently starting giving me the following error:
Undefined Function 'Left' in expression.
This error is being thrown anyplace the Left function is called. This happened previously and I fixed it by just unchecking and checking some of the references under the tools menu. (This was a fix I found online.)
The database is having this issue again (cause? unknown.) and the fix above is not resolving this. Also, during the fix above I unchecked Microsoft Office 11.0 Object Library and when I went back in the object library was not in the list. I selected the 12.0 Office Object library instead, but it made no difference. The error is still occurring.
I guess I have a couple of questions. Do I need to add the Microsoft Office 11.0 Object library to the list and reference it or will it be fine using the 12.0? Also, any help on my Undefined Expression error would be great.
This is a production database that produces time-sensitive materials, so any immediate help would be greatly appreciated!
Thanks ahead of time!