Access: Undefined function “Right” in expression

=========
QUESTION
———
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”

 

=========
ANSWER
———
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.

Note:
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.

 

=========
EXAMPLES
———
see ANSWER

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access 2007
Library
Libraries
Functions
Function

 

=========
REF
———
http://allenbrowne.com/ser-38.html

 


http://www.anysitesupport.com/access-undefined-function-right-in-expression/
http://anySiteHosting.com

By | 2017-12-01T23:47:40+00:00 July 5th, 2011|Access, Computers, Documentation, Microsoft|0 Comments