Hi, newbie here. I've recently lost a lot of data from an Access database.
I've since recovered it, and would like to combine it with additional data
created since the loss. I thought an append query for each affected table
would do the trick, but I'm having problems appending the linked fields (some
are AutoNumber). It won't run due to a variety of violations (due to the
linked field).

What am I missing when I set up my query? Thanks in advance!

Chris