Claude ---
Are you absolutely certain that all fields associated with the key are unique? There has to be a duplicate key somewhere. Make sure that you query your table with the same expression as the index to find dupes.
>I want to convert a reqular index for a field to a primary index (key field). When I try to do it I get the error message
>
> Uniqueness of index "name" is violated (Error 1884)
>
>I tried using a sql select command to find duplicate records by displaying the field count of occurences sort by field value. All counts are 1. I am confused. What causes that error message and how do I fix it? TIA.
------------------------------------------------
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