Key Violation Error

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!
 
R

Rick Brandt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running into error while writing Append Query 3
Access 2002 Append Query Problems 2
How do I avoid key violations in append queries 7
Strange warning message 1
Type conversion failure on Append 12
Remove warning pop up choice 4
Append Query - Key violation 1
Append query wont run because: 8

Top