My two tables contain exact matches on datatypes, there are no validation rules set, no required values set to yes and it all looks like my append query should work. However, I get an error message showing that of 3521 records, 3520 are not appended due to validation violations. There is no violation that I can see and upon checking the data in the original table I notice three new records have been appended (one for each of the 3 attempts?). The data in these new records is a copy of the field names. What's happening?