"witek" wrote:
There is still a question if there is a way to change compare method to case nonsenstive instead of unsing upcase function.

As far as I know, the JET 4.0 provider is case insensitive (not case
sensitive as you imply) and there is no way to specify "Option Compare Text"
or "Option Compare Binary". This option exists in Oracle (the default is case
sensitive) and SQL Server (the default is case insensitive).