Append query validation rule

[Mansoor Ahmad]

Dear All

I am trying to append data from one table to another. It should be simple enough. But when I run the query it says that due to 'validation rule violation' no data has been appended.

I have not set any validation rules for any field and I have compared both tables for their data types, they are same.. What else could be the reason? Would anybody help me out? I am feeling headache now.

Thanks

 

[llkhoutx]

Some field in the table being appended has data which does not satisfy the validatation rule of same field in the table being appended to. Check the validation rules in the design view of the table being appended to.

 

[Rich]

You may be trying to append Null values into a field which does not accept them

 

[Mansoor Ahmad]

Thank you for your reply.

I did find the cause at last. The table where I was appending the data had a field whose 'Required' property was set to 'Yes' and the table which was being appended did not have any values in that field. It did take time but sorted at last.

Thank you for your time.