468,484 Members | 1,567 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,484 developers. It's quick & easy.

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

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
Nov 13 '05 #1
3 1582
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


Nov 13 '05 #2
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

Nov 13 '05 #3
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Rebecca Lovelace | last post: by
9 posts views Thread by Lauren Quantrell | last post: by
12 posts views Thread by David Powell | last post: by
4 posts views Thread by d0wsdkn02 | last post: by
4 posts views Thread by Jim Devenish | last post: by
5 posts views Thread by Salad | last post: by
20 posts views Thread by timmg | last post: by
2 posts views Thread by gieforce | last post: by
reply views Thread by theflame83 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.