append to table

[userZ]

In access 2010, I tried to append a group of records like 100 to my table, I know that already 99 of them are in my table and I expect only one out of the 99 get added. It gives an error that 100 could NOT be added due to key violation. I search for the lines, I found all, except one out of the 100. ???? I repaired the db, still the same… I copied the table to another, renamed, then I see it working as it should. ????

 

[userZ]

No, this table has primary field as well as index keys. After copied and pasted the original table with its data+structure, then renamed the new one works as it should. Not sure what is the difference.

 

[Dale E Hayes]

I have had the same issue. I my case it was not the fields or how they are formatted. It was the data in the field.
I had a phone number field where the field was formatted correctly, but some of the data in the field was formatted as Text. I was importing data from a 3rd party that input the data as text but then changed the format of the column but not the data in it. As I use data from more than one provider I created simple queries to make the necessary changes to the data.