Case Sensitive Keys

[Chuck]

Is there any way to force Access 2007 to recognize that "ABCD" and "Abcd" are
unique values when used in key fields?

I'm not worried about comparisons within VBA modules. I can handle those.
Where I am having trouble is with key fields and non-key index fields.
Access 2007 seems to go out of its way to treat "ABC" as the equivalent of
"abc"; it refuses to allow both of these values in index fields in two
different entries in the same table.

I'm hoping there is an option somewhere that will correct this problem for me.

 

[Allen Browne]

No. JET (the database engine in Access) is not case-senstive.

It may be possible to create your tables in another database that supports
case sensitivity, and link them in Access.

 

[Gina Whipp]

To add to what Allen said... that still not enable you to use them as
Primary Keys or identify them as unique.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm