run macro in external db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CScott - 27 Jun 2005 20:13 GMT

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.

Reply to this Message

Steve Schapel - 28 Jun 2005 10:59 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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.

Reply to this Message

CScott - 28 Jun 2005 14:31 GMT

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 ...

> CScott,
>
[quoted text clipped - 5 lines]
> > I want to be able to run a macro in the data db (which updates the tables)
> > from the application db.

Reply to this Message