Append Query Validation Rule Errors

[leej1]

How can I determine what field in my table is causing the validation error in an Append query?
Thanks

 

[Darrylles]

Hi,

Whats the validation error?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[sonso]

I have similar problems. Unfortunately the error messages aren't very helpful. My problem comes from appending to a table that has its primary key as Autonumber. Access tells me that there are key violations. I thought that it would automaticly increment the key field as new records were entered. I tried taking the Autonumber+the # of records From Original Table (e.g. [ID]+1652) and that didn't work either. Any ideas on this one?

 

[leej1]

Sorry I forgot to insert the type of error. The error is validation rule violations. Hope This helps to define the problem. There is a primary key made up of two fields and an auto number, if this helps.
Thanks For you reply.