Query criteria case sensitive after Access 97 to Access 2002 conversion
Posted on 2007-04-05
I just converted an Access 97 database to Access 2002. Now some of the query where criteria is not working the same way.
The problem is that Access 97 query critieria seemed to be case insensitive, but the Access 2002 query now seems to be case sensitive.
For instance, "eternal" would select "Eternal" in Access 97. The Access 2002 version does not return any "Eternal" records because the criteria is "eternal". If I change the criteria to "Eternal", I get the "Eternal" records. Can I change the behavior globally to be case insensitive, as before?