Key Violation Error

  • Thread starter Thread starter Nick Noone
  • Start date Start date
N

Nick Noone

I have an append query that is giving me the following
error msg and I'm not sure what it means, or how I can
correct this.

"...set 0 field(s) to Null due to a type conversion
failure, and it didn't add 1982771 record(s) to the table
due to key violations, 0 record(s) due to lock violations,
and 0 record(s) due to validation rule violations."

please help!
 
Nick Noone said:
I have an append query that is giving me the following
error msg and I'm not sure what it means, or how I can
correct this.

"...set 0 field(s) to Null due to a type conversion
failure, and it didn't add 1982771 record(s) to the table
due to key violations, 0 record(s) due to lock violations,
and 0 record(s) due to validation rule violations."
Click to expand...

It can mean several things, but most often it is because you are attempting to insert
duplicate records for a field(s) having a unique index.
 
Back
Top