>Hi Ko,
>
>I found the problem, so I guess that's progress... but I can't find the source of it. I found that during the COPY TO command my some of my field names are truncated, thus causing the problems. (The name of the field that is the primary key is changed, and after the first record appended I get the error...)
>
>Any more Ideas ??
>
>Thanks,
>
>Gadi Hutt

---

If you copy data to a free table, then you can only have field names with a lenght of 11 characters.
If you then append from that table with truncated field names, the primary keys will not be found, cause they have another name now.
Thus you get empty PK's and that is causing the problem.