• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

update to UCASE in access 2007


I tried to run the following sql in access 2007 but got error "undefined function ucase"

UPDATE Info SET name= ucase([name]);

Please suggest.
1 Solution
Is there any chance it's a missing library reference?

Go to Tools -> References and check what you've got.  Unclick any references that say MISSING.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Open the VBA editor.
Tools>>References. Look for nay listed as:

**MISSING <SomeReferenceName>

If any, resolve.

Also, is your db in a Trusted Location ?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now