Update Query to a Different DB

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Update Query to a Different DB

Post by Leesha »

Hi,
Is it possible to update tables in a different Access DB. For example, I have a blank database that needs information entered into tblAdministrativeInformation before it can be deployed. This is the only data that changes in the destination database. I am looking to update it from a different database that stores the history of the data that has been updated.
Thanks
Leesha

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Update Query to a Different DB

Post by HansV »

You could create a link in the history database to tblAdministrativeInformation in the target database. When you add or edit records in the linked table, you actually add/edit them in the other table.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Update Query to a Different DB

Post by Leesha »

This is perfect! I was thinking of something along this line but had it backwards, linking the destination DB to the Admin DB. This would have created extra steps of having to delete the link after the info was in the permanent table. I just love how your brain works!
Thanks again,
Leesha