Seen this before ? (Built in function giving error)

[chris_dono]

Runtime error, cannot use Ucase() in query expression ?


Ucase is part of access and has worked from day 1, then recently stopped....

The only thing I've found is that if you compact the datbase on a machine that has Excel 97, then use it on a machine that has Excel 2000 or higher, the error occurs, but not the other way around.

Should I try another function ?

 

[KenHigg]

Runtime error, cannot use Ucase() in query expression ?


Ucase is part of access and has worked from day 1, then recently stopped....

The only thing I've found is that if you compact the datbase on a machine that has Excel 97, then use it on a machine that has Excel 2000 or higher, the error occurs, but not the other way around.

Should I try another function ?

Do it 'the other way around'(?)

kh

 

[Mile-O]

Check for a missing reference.

 

[RoyVidar]

I'll echo SJ McAbney here, and especially, if you're doing some Excel automation, and have that library checked, check that library especially (version 8.0 in 97, 9.0 in 2000). This goes for other Office Application libraries checked too.