case sensitive text in a primary key

J

jbb

I need to create a primary key for a table that contains "DB" and "db" but MS
Access says that I have duplicate keys. Is there away around this without
changing the data values?
 
J

John Vinson

I need to create a primary key for a table that contains "DB" and "db" but MS
Access says that I have duplicate keys. Is there away around this without
changing the data values?
Click to expand...

Unfortunately, no, not in a JET database. The engine is
case-insensitive.

John W. Vinson[MVP]
 
Top