Validation Rules Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why do I get an "validation rules violation" error when I have no rules set
when trying to run an append query?
 
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
Problem with combining tables!!!! 2
data validation in two tables 1
Access Validation rule of 1 field based on a field of another table 1

Back
Top