A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Append query for data recovery



 
 
Thread Tools Display Modes
  #1  
Old July 9th, 2008, 07:43 PM posted to microsoft.public.access.queries
Steel Banana
external usenet poster
 
Posts: 9
Default 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  
Old July 9th, 2008, 08:56 PM posted to microsoft.public.access.queries
BlueWolverine
external usenet poster
 
Posts: 138
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.