Validation Rule Violation HELP!!!

[Guest]

I've got a append query that appends records into another table. The
destination table data types are all text, and none are exceeding the
character limits set. I've got a group of 35 records that I'm appending into
the destination table- but 6 of them error out with a "Validation Rule
Violation" and 29 of them get into the destination table just fine. I'm not
able to identify ANYTHING wrong with the data, lengths are all fine, the
primary keys are there - not duplicated, I'm going crazy trying to find the
problem. This append query is a part of an automated business process that
bombs out every night when it runs because of this append error.

Anyone have a clue on what else to check for - for a Validation Rule
Violation? When I click on the help button (the one that says: For an
explanation of the causes of the violations, click Help.) it simply explains
what an append query is.

Thanks for your help!
Jesse

 

[Guest]

You mentioned the primary key; however, have you double-checked for any other
unique indexes?

Have you checked each field in the table for validation rules?

Is Required set to No on all fields? If Yes, you need to make sure that all
records have something for that field.

I often have had luck with setting Allow Zero Length to Yes.