Duplicated Primary Index

  • Thread starter Thread starter Scott Trowbridge
  • Start date 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
 
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.
 
Back
Top