Append Query

  • Thread starter Thread starter Shelley Atlas Air
  • Start date Start date
S

Shelley Atlas Air

I am using Access 2000. I ran an append query to append a small table (12,624
records) to a big table (151,122 records) in the same database. I then got a
message saying that 63 records will not be appended due to "key violations".
I ran the query anyway, and examined the big table. All of the small table is
included except the 63 records. I cannot figure out why these 63 records were
not appended.

I have been running this same append query at the end of every month, and it
always appended all of the records in the small table in the past. I cannot
detect what is different this month.
 
It means you have a field in the destination table that has an index or
primary key that requires unique values or the data in the field in the
source table is not allowed in a destination field that is indexed. For
examples a Null value where nulls are not allowed.
 
Back
Top