run macro in external db

[Guest]

I have split my db into a application db and data db utilizing table links.
I want to be able to run a macro in the data db (which updates the tables)
from the application db.

 

[Steve Schapel]

CScott,

The macro should be in the application db. There is no problem to have
the macro in the application db to work with the data in the linked
tables in the data db.

 

[Guest]

Steve,
Thanks for responding.
The tables I am linking to are created by an extensive set of queries in the
data db.
The "source" tables are very large (over 500K rows) and are updated nightly.
To increase performance in the application db, I run a set of queries (via
macro) to create the linked files.
I would like to have a command button on a form within the application db
that would run the macro within the data db to re-create the linked files.
I know Access pretty well, but am not familiar with VB.
Thanks again ...