Access Can't Append Message



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

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

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



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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question