Missing lcase function in query

[snerting]

Hi!

I made a tool in Access (linking tables from Oracle), and some queries use the lcase() (lowercase) function, which works fine when I run it, but it throws an error for other users. They have the same version of office as I do, both with SP2 installed.

The error:
Run-time error '3075'. Function is not available in expressions in query expression 'lcase(table_name)=lcase('Foo')'

Any ideas?

 

[mp9]

As a workaround, try replacing your LCase with StrConv, e.g. replace LCase(table_name) with StrConv(table_name, 2)

 

[snerting]

Thanks, I'll try to include that

 

[snerting]

StrConv gave the same problem. Works for me but not for the other user

 

[PHV]

Check the references in other users Pc:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886