Your primary key is not unique. If you add more than 1 record without setting a unique value for your key field then your 2'nd appended record will cause this error. If this is the case try setting a default value for this value that is unique.
>I am using a table with optimistic table buffering. I am trying to append from another table. Every time I try this I get 'Uniqueness of index myindexname violated. The records that I am adding do not exist in the table I am appending to.
>
>Can anyone help or explain?