If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"validation rules violation"
Why do I get an "validation rules violation" error when I have no rules set
when trying to run an append query? |
#2
|
|||
|
|||
Answered in m.p.a
|
#3
|
|||
|
|||
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. Jeff25550 wrote: Why do I get an "validation rules violation" error when I have no rules set when trying to run an append query? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Validation Rules? | Charles | Using Forms | 1 | September 30th, 2004 07:19 AM |
validation rules violations | Elsie | General Discussion | 1 | June 22nd, 2004 06:33 AM |
Retrieving Email settings, rules, etc. | XB | Installation & Setup | 3 | May 18th, 2004 11:44 PM |