By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.