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?