Duplicated Primary Index

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Scott Trowbridge" wrote in message
...
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