Case sensitive primary key

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.
 
D

Douglas J. Steele

Sorry, no. The only way is to convert the string to its numeric
representation, and store that.
 
G

Guest

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

Top