Case sensitive primary key

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

 

[Douglas J. Steele]

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

 

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


.