How do I make data entry case sensitive?

[Og, son of Moge]

I'm in datasheet view. I enter data for record one, Abc. I enter data for
record two, ABc. These two records should be unique. Access says I have a
duplicate record. How do I make Access recognize them as unique?

 

[Allen Browne]

You can't.

At the engine-level, Access is case-insensitive.
So if you have a unique index on the field, you will not be able to enter 2
records for Abc and ABc.

If that is essential, you would need to use a different back end than JET
(i.e. attached tables, not tables in Access.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[david epsom dot com dot au]

If you define a text field as binary instead of text,
you can put a binary unique index on it, instead of
a text index.

It is one of the options discussed (with some of the
limitations and drawbacks) at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244693
How To Perform a Case-Sensitive JOIN Through Microsoft Jet

The biggest drawback is that you probably can't enter
data directly into your datasheet view (unless you use Access 2.0)

(david)