Validation Rule?

[Dug]

When I run in append query (which has worked in the past), Access now tells
me all but 7 records violate some unforseen validation rule. All the records
contain the same fields of the same length and there are no validation rules
on any of the fields in the target table. Help!

 

[John Spencer]

Do you have a UNIQUE index on a field?

Do you have a relationship where a field is dependent on a field in another
table and you are putting in values that don't exist in the other table?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Dug]

I do have a unique index on one field, but there are no duplicate values in
table being inserted. I was able to reverse the append operation - appending
records from the target table to the source - but I cannot go back the other
way. I also checked field lengths and types and everything seems to be in
order.

 

[Dug]

After trial and error it appears allowing the fields to accept zero length
strings was the issue.