Key Violations

[Victoria]

I'm attempting to append some data to one of my larger
databases. When I do an append query, it says that it
can't load 384 records due to key violations. When I do a
cross-check on the two tables to make sure the primary
keys aren't being violated, I get maybe 7 problems, not
384. Any suggestions?????

 

[Rick Brandt]

I'm attempting to append some data to one of my larger
databases. When I do an append query, it says that it
can't load 384 records due to key violations. When I do a
cross-check on the two tables to make sure the primary
keys aren't being violated, I get maybe 7 problems, not
384. Any suggestions?????

That error is a bit more generic than you think. "Key violations" are not
limited to Primary Key issues. Do you have any other unique indexes? Does
the table have any foreign key fields that are enforced?

 

[Victoria]

I have only one indexed item, which I've allowed to have
duplicates. Any other ideas?

 

[Rick Brandt]

I have only one indexed item, which I've allowed to have
duplicates. Any other ideas?

The only other thing I can think of is to attempt to copy n' paste the
records. The rejected ones will be placed into a "Paste Errors" table
where you can examine them to see what the problem might be. Then you can
attempt to copy n' paste one of those records and fiddle around with it
until you determine the field(s) that Access is balking on.