Duplicated Primary Index

  • Thread starter Scott Trowbridge
  • Start date
S

Scott Trowbridge

Hello,


I've got a database that I'm importing and then generating a primary key and
MS is generating an error say Dup. Key. The two fields in question is an
account number and a unique sequential alpha/number field. As an example:

Account Key

12345 <a
12345 <b
12345 <c
..
..
..
12345 <A
12345 <B


So MS Access looks at the '<a' and '<A' and considers them to be the same
and not understanding the difference in the case. How can I get around this
issue?

Scott
 
A

Allen Browne

You can't get around that. JET (the database engine in Access) is not
case-sensitive. You will need to convert the lower case values to a
different character, or use a different data engine.
 

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

Need largest number 6
Duplicate issues across multiple columns 1
Notify User of Duplicate Records on Multiple Fields 6
No Duplicates for Full Name 7
Primary key to prevent duplicates 8
Duplicate Values in the index, primary key or relationship 4
Primary key for multiple field 2
create an Auto-increment field for use as the primary index betwee 1

Top