All of a sudden when I am running a query that includes the standard Microsoft Access function Right(), it is erroring out on me with the error: “Undefined function “Right” in expression”
Apparently functions like this can go missing from time to time for varying reasons.
To get around this issue, go to code view by hitting Ctrl+G from any where in Microsoft Access.
Then Tools menu, References
Look for any library prefaced by “MISSING: …”
If you can do without this library, simply un-check it and click OK
(unless you are an advanced coder, or installed some library separately, in all likelihood, you can do without the library)
If not, click the Browse button and try to hunt it down.
We noticed this most often when opening a Microsoft Access file in Access 2010, and then opening it later in Microsoft Access 2007, or vice versa.
Switching versions like that seems to exacerbate issues of this nature.
APPLIES TO / KEY WORDS
Microsoft Access 2007