Access Can't Append Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
Back
Top