Append Query Issues

[Humreid]

Hello people. I am having issues with append query, Serious one. I built a second table that have the exact properties and characteristics as the table it will receive data from. But each time I want to append data to it, I'll be welcome with validation rule violation error. It's very annoying and time consuming. Please I need help on how to deal with it.
When I view the query in datasheet view, it will display exactly how it should be. But when I run the query, the validation rule violation error kicks in and only append just one record out of 18 and leave the remaining 17 behind.

[ranman256]

check all fields for validation rules in the table properties.
if not, you must play detective.
I start with the query off all my fields, run
if error, I delete 1 field from the query, run,
delete the next, until the query runs. That is the culprit field.

(thanks for the helpful message box Microsoft)

[Gicu]

If it adds only one record you probably have a unique index (such as the primary key or another one) in one of the fields.

Cheers,

[Humreid]

OK. Thank you

[Bullschmidt]

And just to be clear if you try to append a record with blanks in required fields that won't work...

[Bruce McKool]

You guys are amazing!