Append Query Validation Rule Violations

[Jayne]

I'm trying to create an Append Query in Microsoft Access to add some data from one table into another table. I checked all of the properties and fields to make sure there are no validations. I have allowed zero length, and have tested the validation rules under the tools section of the design tab on both of the tables. When I run the Append Query, I still get an error that says 0 records added due to validation rule violations. Any suggestions on what else to do or check in order to resolve this problem? Thank you!

 

[ypma]

Have not got a solution but , if you have not tried already my suggestion are:-.
1. Confirm that you are not entering data into a field that does not permit duplicates.
2. check that text is not being appended to a number field .
3. Check for validating dates to ensure the value falls within the specified format
4 .Are there any auto number fields ,is numbering sequence causing the problem ?
If that is all OK ,Make a backup of the database and try to append a single test record with just a few field of data field and if that works you could slowly add field until you create a violation
There may well be other solution but that all i can offer at this time

Best of Luck