Case sensitive primary key

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

Guest

Is there anyway in MS Access to create a case-sensitive
primary key so that INTERFACE is not equal to Interface. I
know there is a COMPARE attribute in VB modules for
controlling the comparisons there and several functions I
can use, but I was hoping to find something that would
work without having to store some unicode converted string.
 
Sorry, no. The only way is to convert the string to its numeric
representation, and store that.
 
Thanks for the very quick reply.
-----Original Message-----
Sorry, no. The only way is to convert the string to its numeric
representation, and store that.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


string.


.
Click to expand...
 

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 primary key 2
Making .FindFirst Case-Sensitive 4
How do I make a primary key field case sensitive? 2
Case Sensitive Keys 2
distinguish upper/lower case in unique index? 4
Same record/Primary key in multiple tables 0
Case sensitivity & Primary key 5

Back
Top