How do I make a primary key field case sensitive?

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

How do I make a primary key field case sensitive? I.i. h2 and H2 be
considered different and both accepted as values in the same table?
 
aa said:
How do I make a primary key field case sensitive? I.i. h2 and H2 be
considered different and both accepted as values in the same table?
Click to expand...

You can't, at least not when using Jet (mdb) tables. You would have to use
a database engine that has the option for case-sensitivity.
 
You could use an Access ADP file which using the SQL Server Engine to store
the data.

Rick
 

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
Case sensitive password 1
Oversensitive touchpad on modern laptops 0
case sensitive filter 5
No Primary Key! 4
Syncronizing data field from one table field to another table 1
case sensitive primary key 2
primary key - concatenated or autonumber? 6

Back
Top