Key Violations

  • Thread starter Thread starter Victoria
  • Start date Start date
V

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?????
 
Victoria said:
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?????
Click to expand...

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 said:
I have only one indexed item, which I've allowed to have
duplicates. Any other ideas?
Click to expand...

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