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