Text insert in indexed fields with "no duplicate" property

  • Thread starter Thread starter Winfried
  • Start date Start date
W

Winfried

Hi,

I have an ACCESS database with some columns. One of them lets call it
SURNAME is of type "text". In the field properties I have set it up in
"Indexed" with "Yes (no duplicates)". Further I want to add names with
upper and lower letters and I want to distinguish between names like
"Joe Brown" and "joe brown". Unfortunately ACCESS tells me that there
is a violation.

Question: Is there a way to add strings described above without the
violation message?

Thanks in advance
Winfried
 
Maybe use asc() to convert the string to ASCII and then compare the
ASCII values. It takes extra work though...
 

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

Increasing the number of indexed fields with no duplicates 6
BeforeUpdate event: Trouble with Cancel = True 14
distinguish upper/lower case in unique index? 4
Multi Column Unique Index with nulls 2
Writing SQL code to delete duplicate records 0
Finding an index in an Access DB 1
Primary Key Index 2
Index Duplicates 7

Back
Top