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
Update Query to a Different DB
-
- Administrator
- Posts: 78446
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Query to a Different DB
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
Hans
-
- BronzeLounger
- Posts: 1487
- Joined: 05 Feb 2010, 22:25
Re: Update Query to a Different DB
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
Thanks again,
Leesha