"validation rules violation"

  • 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?
 
Do you have unique indexes on any fields? These are treated as validation
rules, so if your append query violates the index rule by trying to add a record
that already has a value in the table you will get this error.
 
You must log in or register to reply here.

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? 3
Append Query..... 6
Running into error while writing Append Query 2
Access 2002 Append Query Problems 1
How do I avoid key violations in append queries 7
Append Query isn't working 2
Validation Rule Error 1
Validation Rule Violation HELP!!! 1

Back
Top