What is the limit on number of fields for an append query, or is the limit expressed in some other way? I have one that gives me the mysterious "key violation" message, but it works ok if I remove any 4 fields. I experimented making a copy of the table that is receiving data and tried to append it to the original table, so I am sure that there is no problem with the field properties being mismatched.
MY ERROR: I SAID "key violation", I meant "validation rule"
MY ERROR: I SAID "key violation", I meant "validation rule"
Last edited: