validation rule violation error

[karen]

I am getting a validation rule violation when I try to
append to an existing database even though I do not have
any validation rules and all the data types are similar in
both the tables....

Thanks

 

[Allen Browne]

Many things can cause a validation error, e.g.:
- a field has its Required property set to Yes, but the record you are
adding has a null in that column.

- the field has a LimitToList combo as its Display Control.

- the field has its Allow Zero Length field set to No (as it should), but
the record you are adding contains a zero-length string (not a Null).