"undefined function 'Right' in expression"

[Keith]

I've converted an application that was developed in Access
97, to Access 2000.
Within one of the expressions of a query, the RIGHT
function is used. When I try to run the query, I receive
the error message "undefined function 'Right' in
expression".
The query worked fine in Access 97.
Any idea on why I'm receiving this error?

 

[Betsy]

I had this problem once and solved it by creating a blank database (in 2000)
and importing all the objects from newly converted 2000 database. Cannot
explain why it worked, but it did.

HTH- Betsy

 

[Armen Stein]

I've converted an application that was developed in Access
97, to Access 2000.
Within one of the expressions of a query, the RIGHT
function is used. When I try to run the query, I receive
the error message "undefined function 'Right' in
expression".
The query worked fine in Access 97.
Any idea on why I'm receiving this error?

This usually means that you have a missing reference. From any code
window, select Tools..References to see if any are listed as "MISSING".
If any are, you'll need to either find them on your PC or uncheck them
if they aren't needed.

Also, if you moved from Access 97, you'll probably have code that uses
DAO. If it isn't already in your list, add Microsoft Data Access
Objects (latest version) to your list, then move it above ActiveX Data
Objects.