G Guest Nov 29, 2004 #1 Why do I get an "validation rules violation" error when I have no rules set when trying to run an append query?
Why do I get an "validation rules violation" error when I have no rules set when trying to run an append query?
J John Spencer (MVP) Nov 30, 2004 #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.
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.
