Updating another DB and controlling from a differnt DB

[Steve5]

Hello All,

How would I run a procedure in DB2 from DB1?

 

[DJN]

Open the 2nd DB from the first DB and do what is necessary from there. This code will open a second DB from the first, if that is what you mean?

Dim stAppName As String

stAppName = "C:\Program Files\Microsoft Office\Office11\msaccess.exe " & "YourPathname"
Call Shell(stAppName, 1)
DoCmd.Quit

 

[Steve5]

DJN,
I appreciate the response.

I have DB1 producing a report through a linked table in DB2.

The steps I must take to update the report consists of downloading data into a text file that is linked in DB2, then I must hit a "Update" button that runs a few lines of code that update a table in DB2.

Then I go to DB1 and produce a report that is linked to DB2's table.

I was hoping someone could show me how to run the update code that is in DB2 from DB1 without having to open the DB2 and do it manually.

I hope these details help provide a better idea of what I meant. Sorry for the vague explanation on the original post.

 

[edtab]

It would appear to me that it is possible for you to link the text file to DB1 then do the updating of the tables from DB1 as well by copying the existing update code from DB2 into DB1.

As long as you link all the necessary tables to be updated to DB1, then you should be able to do everything from within DB1.

Let me know if it works for you.