UCase Function not recognized in Access

  • Thread starter Thread starter RAN
  • Start date Start date
R

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.
 
Sounds like one of the References is MISSING. tkelly offered a way to look
into this.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
The references match on both machines.

tkelley via AccessMonster.com said:
Go into a VBA module on each machine and check that they have the same
refernces.

Tools|References
Click to expand...
 
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.
 
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.
 
Back
Top