Case Sensitive Keys

  • Thread starter Thread starter Chuck
  • Start date Start date
C

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.
 
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.
 
Back
Top