Maybe the Option Compare Database/Text/Binary ?

http://support.microsoft.com/kb/98227/en-us/

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"JimP" <jpockmire@pockmiresolutions.com> wrote in message
news:2uWdnQmEk9TqH43VnZ2dnUVZ_qiinZ2d@comcast.com. ..
> I'm working with MS-Access and (2) SQL Server db's, both with case
> sensitivity enabled .
>
> In one case, I have a query that links a local table, with lower case
> codes,
> to a SQL Server table with upper case codes - All matching records are
> retrieved (case sensitivity apparantly is NOT enforced)
>
> In the other case, the query does not retrieve any records (case
> sensitivity
> apparantly is enforced).
>
> I would like to NOT enforce case sensitivity, and am at a loss to figure
> out
> why it is not enforced in the first case and is in the second.
>
> Is there a property somewhere that I can set?
>
>