Tip Duplicate Trusted Locations can give errors similar to 'missing reference' errors. (1 Viewer)

[pondlife]

We have an accdb database developed in Acc2010 on an XP PC. On a new Win7 PC with Acc2010 the database worked fine for UserA, but UserB on the same PC got the error: Function is not available in expressions in query expression "Ucase([MyField])..." (Ucase() is the only function in the query expression. The same happened with Lcase() in other query expressions.)

This sort of error is usually observed when there are missing Library References. There were were no missing references for either user. The database compiled successfully for both users, etc.

Eventually we found the problem: the file location appeared twice in UserB's Trusted Locations. We deleted one of the duplicate locations, and all was well.

Hope that helps some other poor soul.

 

[Pat Hartman]

Thanks for the tip.

 

[ChrisO]

Can someone please verify the above fault?

The service packs involved are not mentioned.

Also, “We deleted one of the duplicate locations, and all was well.” is insufficient testing.

Under this circumstance, I would suggest the following as a minimum test…
Delete the duplicate and test.
Close and restart Access; test again.
Reinstate the duplicate; test again.
Close and restart Access; test again.
Delete the duplicate; test again.
Close and restart Access; test again.
Try to get verification of the results of the above method from another source.

It would seem to me to be obvious that if someone went to the above trouble to test something then they would have mentioned it. It is required to state the conditions of test when someone publishes the results of their test else the results are meaningless.

Can someone please post the method they used to verify the above fault?
If we can get verifiable proof we should feel confident in sending it to Microsoft for a fix.

Chris.