case sensitive text in a primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

case-sensitive primary keys 10
Update primary Key. 1
Same record/Primary key in multiple tables 0
primary key - concatenated or autonumber? 6
Adding a primary key 3
importing dilemma 1
Importing data 3
Duplicate values in the index, primary key, or relationship messag 2

Back
Top