How to Trigger Macros in a Access DB from Another Access DB

[Momoko]

Hi,

I have three Access Databases, say A, B and Main, in which data flows
between Main and A, Main and B. Within A and B, there are macros that
trigger computation within the databases. I need to call these macros
in A and B from Main database.

My understanding is that ODBC is used for SQL based queries, not for
calling modules or macros within the databases. What should I build
to create a control within the Main database such that it will call a
macro within another database?

Thanks in advance,
Momoko

[Tom van Stiphout]

On 24 Jun 2004 20:23:25 -0700, mo*********@hotmail.com (Momoko) wrote:

Automation.

Or if it's just a single invocation, the /x command line argument.

-Tom.

Hi,

I have three Access Databases, say A, B and Main, in which data flows
between Main and A, Main and B. Within A and B, there are macros that
trigger computation within the databases. I need to call these macros
in A and B from Main database.

My understanding is that ODBC is used for SQL based queries, not for
calling modules or macros within the databases. What should I build
to create a control within the Main database such that it will call a
macro within another database?

Thanks in advance,
Momoko

[MacDermott]

You haven't said whether A and B are back ends (data tables), with a single
front end (forms, reports, etc) Main, or the other way around.
In general, it's usually a better design to have all your computations
together in a single front end database, rather than stored together with
the data.

I'm also a bit concerned that these macros are triggering computation within
the databases.
This sounds as if you are storing calculated values, which is seldom a good
use of the relational capabilities of Access.

HTH
- Turtle

"Momoko" <mo*********@hotmail.com> wrote in message
news:fc*************************@posting.google.co m...

Hi,

I have three Access Databases, say A, B and Main, in which data flows
between Main and A, Main and B. Within A and B, there are macros that
trigger computation within the databases. I need to call these macros
in A and B from Main database.

My understanding is that ODBC is used for SQL based queries, not for
calling modules or macros within the databases. What should I build
to create a control within the Main database such that it will call a
macro within another database?

Thanks in advance,
Momoko

[david epsom dot com dot au]

You can use Access Automation, DDE, or Shell to MSACCESS.EXE to
run a macro from a command line.

"Momoko" <mo*********@hotmail.com> wrote in message
news:fc*************************@posting.google.co m...

Hi,

I have three Access Databases, say A, B and Main, in which data flows
between Main and A, Main and B. Within A and B, there are macros that
trigger computation within the databases. I need to call these macros
in A and B from Main database.

My understanding is that ODBC is used for SQL based queries, not for
calling modules or macros within the databases. What should I build
to create a control within the Main database such that it will call a
macro within another database?

Thanks in advance,
Momoko