Run macros in 16 other dbs from 1

[RWD715]

I have 16 Access dbs and want to run their macros from a "central" db. Each
db has a "RunAll" macro that runs all of the macros in the individual dbs. I
think that I did this, or had it done for me, in 00 or 01 for another project.

 

[Steve Schapel]

RWD,

You can use a RunApp action in your macro. The Command Line argument
will be something along these lines:
"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\YourDB.mdb" /x
NameOfMacro

Having said that, your need to do so, and the 16 separate database
files, makes me very suspicious of a poor design of your system. If you
would like to explore this aspect, let us know some more information
about all these databases, what distinguishes them from each other, and
what is the relationship between them.

 

[RWD715]

Hello Steve,

I had hoped to hear from you and got the answer that I expected, having seen
it in your response to a similar question. I’m not VBA literate, but if
that’s the only choice that I have…

As for the design, I have a weekly report to produce covering 22 different
and dissimilar topics from a wide variety of data sources that is delivered
in an Excel workbook that has 22 worksheets linked to tables created in the
dbs. While I suppose it would be possible to create a single db to process
all of the data, it would be very large and cumbersome (close to 900
queries). I chose to segregate the different data streams into separate dbs
for ease of development and trouble shooting.

Thanks for the response.
Bob

 

[Steve Schapel]

Bob,

Where did I say anything about VBA? Yes VBA would be a good choice, but
my reply was a macro solution, using a RunApp action.