Hiya Randy ---
This error is due to having more than one row (records) contain the same value as another. Every primary key value must be unique. A common reason for this error is a blank primary key field, giving you this error everytime you do an APPEND BLANK.
Your solution is to find the rows with duplicate keys and make them unique. Then you can make your index Primary.
>I am trying to change one of my tables index to a primary index and when I try to do this I get a error message "Uniqueness of index account is violated". How can I make this a primary key.
>
>Thanks Randy
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05