Access Can't Append Message

[Guest]

I am trying to append two large tables of contact data. One table has 10,000
entries, the other has 7,000 entries. This a simple append query. The Error
message reads:

Microsoft Office Access
Microsoft Office Access can't append all the records in the append query.
Microsoft Office Access set 0 field(s) to Null due to a type conversion
failure, and it didn't add 594 record(s) to the table due to Key Violations,
0 record(s) due to lock violations, and 0 record(s) due to Validation Rule
violations.

Do you want to run the action query anyway? etc.....

Please explain the Key violations and how I can include them.

Thanks.

 

[jlepack]

Those 594 records would create an issue with one of your primary keys.
There are probably data items that would create duplicates in your
primary key or a field that is indexed with no duplicates allowed.

Jason Lepack

 

[John Spencer]

Key violations are usually due to duplicate values in the primary key of the
table. Caused by
-- The source table has duplicates
-- The source table has values that already exist in the destination table

OR
Key violations can be caused by foreign key problems when relational
integrity is set and a value in the foreign key field does not exist in the
"parent" table. So if your source table has a relating field with a value
that does NOT exist in the "parent" table's field, you can get a key
violation.

 

[Guest]

I checked and you are right. One of the fields has a primary key. Thank you.