File Violations when Appending records

[Meryl]

I am tearing my hair out on this one. My office had a fire and we lost our
entire database including the backup. I just recoded most of the application
and I'm trying to append records to one of our main tables. Even though all
the records look fine when I view the datasheet, none of them get appended
because of "validation file violations". I have no idea what could be
causing that. I have compared both tables and can't see what the problem is.

Please help!

Thanks.
Meryl

 

[Klatuu]

Check your table in design view to see if there are any validation rules
defined. Also check to see if any fields are not allowing duplicates or null
values.