Error Message on Append Query

[jketcher]

I am getting the following error message when running an append query. It only happens when I am using two of about 200 records from an existing table. The message is:

'You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule. Please correct and try again'

I did some research on the internet and found some information on it and made some corrections to the database to make the two records that are having issues consistent with the other records for one field, but that has not helped.

Do any of you have experience with this message? Is there a way I can find out which field is causing the issue? VBA code?

Thanks, jketcher

 

[HiTechCoach]

I am getting the following error message when running an append query. It only happens when I am using two of about 200 records from an existing table. The message is:

'You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule. Please correct and try again'

I did some research on the internet and found some information on it and made some corrections to the database to make the two records that are having issues consistent with the other records for one field, but that has not helped.

Do any of you have experience with this message? Is there a way I can find out which field is causing the issue? VBA code?

Thanks, jketcher

I would look at the relationships and the table design for validation rules.