Error Received When Appending

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

Guest

I have an Append query that gives the following warning message when
executed...
"Didn't add 2344 records to table due to key violations."

There are 30+ fields in this table. A total of 4700 records.

What should I look for to resolve the 'violations'?

How else can I get all these records into the 'other' table?
 
1. Does the append query attempt to assign a value to the primary key field?

2. Are there other unique indexes on this table?

3. Are there any foreign key fields in this table i.e. fields that relate to
other tables? If so, are you assigning values that are found in the lookup
table? If there are foriegn key fields, but your query is not assigning
values to them, open the table in design view and remove any Default Value
on these fields. (Typically Number fields default to 0, and the zero does
not match any value in the lookup table.)
 
Ahhhh, I was trying to append to a table that had Unique record numbers.
Removed that field and was able to append ALL my records.

Thank you mate.
 
Back
Top