Can I run a macro in a stored database from an open database?

[Beverly76]

I had about 20 tables linked directly to Excel, but that slowed my database
down significantly. I created an intermediate database with the links in
place and then queries to make tables out of the links and export them to my
main database. This successfully sped up the main database reports.

Now, I am trying to automate the process of updating the data. I have a
macro in my stored database (Datafiles.mdb) which runs the queries that
update the tables in (Project.mdb).

How do I tell Access to get to that macro, or alternatively tell Access to
run those queries in (Datafiles.mdb) ultimately from my switchboard in
Project.mdb?

 

[Steve Schapel]

Beverly,

Well, you can run a macro in another database by using the RunApp
action. The Command Line argument would look something like this:

"C:\Program Files\…\Msaccess.exe" "C:\YourFilder\Datafiles.mdb" /x
NameOfMacro

But I can't see why this is necessary. If you already linked to the
tables in Datafiles.mdb from Project.mdb, then you already have direct
access to the data, and can use queries within Project.mdb to transfer
or manipulate the data.