If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Append query for data recovery
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 |
#2
|
|||
|
|||
Append query for data recovery
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. -- BlueWolverine MSE - Mech. Eng. Go BLUE! "Steel Banana" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|