UCase Function not recognized in Access

[RAN]

I have a new person with a new PC using an Access database that I developed.
In it there's a query using the function UCase(String). The query keeps
failing with the message that UCase is not a valid function. Any suggestions?
It's running on Access 2003. Thanks.

 

[Jeff Boyce]

Sounds like one of the References is MISSING. tkelly offered a way to look
into this.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[RAN]

The references match on both machines.

Go into a VBA module on each machine and check that they have the same
refernces.

Tools|References

 

[Sylvain Lafontaine]

Does the new PC has a different version of Windows than the other machine?
After copying it, try to decompile the file on the target machine before
using it. For example, go to the references, add a new (and dummy)
reference; close the References window (important), reopen it again, remove
the dummy reference and Compact&Close the database file after that.

A second option for doint the decompilation would be to create a shortcut
with all the three following parameters:

/decompile /compact /repair

It's usually best to do this decompilation on the target machine; ie., the
new PC in your case.

 

[Douglas J. Steele]

Just a comment that if you are creating the shortcut Sylvain suggested,
remember that it needs to be a shortcut to msaccess.exe, not to the mdb (or
mde) file.