Can a macro run several databases?

  • Thread starter Thread starter Jan Nademlejnsky
  • Start date Start date
J

Jan Nademlejnsky

Is this possible:

I have several (49) identically structured databases with the same update
macro in each. Each macro has shortcut on desktop.
Currently I have to:
click 1st shortcut, wait until the update macro finishes, and close
Access
click 2nd shortcut,wait until the update macro finishes, and close
Access....
repeat all above 49x.
This process takes about 40 min to complete.

I want to click one button (shortcut) which would do the above for me. Is
there any other application which I could use to do it?

Thanks for your help.
Jan
 
Jan,

I would be very curious to *why* you have 49 identically structured
databases, and what the purpose of the update is. If you don't mind me
saying so, it is very likely that there is a simpler way.

In any case, there are various ways this could be further automated.
For example, I think it shoud work to have a macro in a "master"
database, with a series of RunApp actions, one for each of the 49 other
databases.
 
Back
Top