Validation Rules Error

G

Guest

Why do I get an "validation rules violation" error when I have no rules set
when trying to run an append query?
 
A

Allen Browne

You can still get this error if the field properties prevent the import.

For example, if you have the Required property set to Yes for a field, and
the entry contains no value for this field. Or if you have the
AllowZeroLength property set to No (as you should), but the import tries to
insert a zero-length string.
 

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

Validation Rule Violation 4
exit sub on validation rule violation 4
validation rules violations 1
Access lock violation 2
Validation and System error messages 4
data validation in two tables 1
Access Validation rule of 1 field based on a field of another table 1
Problem with combining tables!!!! 2

Top