Append query for data recovery

[Steel Banana]

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

 

[BlueWolverine]

Hello, I am by no means an Access master but I have a couple ideas I want to
float you.

Linked tables I assumes means either linked with a relationship to another
table in your DB, or linked to an external table.
1. I have found that referential integrity messes me up often because I
forget to add something the list of unique "names" before trying to assign
that name to a record in a related table.
2. I have fond importing data from excel via a linked table can be tricky.
For instance, I had an input page in excel that got dumped into a std access
table. well my "model year" was text in access but of course it was a number
in excel so that caused eveyr sort of key violation I could come up with. My
solution was to write a macro to add ="#" to each model year cell. (I had
some reason I didn't just change the table to a number in access, i think it
was a good reason)

That's my best guess. I hope that helps, or someone smarter than I helps you.