Database that runs macros in another DB

[BED]

Hello all,

I have 4 databases that are too big to combine into one. They are all directly related, so i created a 5th DB with a Macro in it, that runs the 4 update macros in the respective DB's.

Little confusing but let me know if more clarification is needed.

My issue is that im using the RunApp command in the macro builder, and have 4 of those in a row.

When i click the master update button, it opens all 4 DB's and trys to update them all at once (which i cant do due to system regulations at work).

Is VBA needed, or do you think i can do it with the expression builder.

Im fairly good at editing, understanding, and modifying code, but starting it is the hard part.

Im not expecting anyone to write the code for me. I can google it and get a rough copy and then see where my issues are..... But id prefer to have the update macros run one at a time, and que the next one when the previous is finished.



What do you guys think.

[HiTechCoach]

I would use VBA.

Try converting your macros to VBA code as a starting point.

If it were mine, I would create a front end that links to the tables in the other databases. This way you can run code in the front end that updates the tables in the other database. This way you do not have to open the other database.

Boyd Trimmell aka Hi Tech Coach ( HiTechCoach.com free Access stuff)
Microsoft Access MVP 2010
Business Process Management - Accounting/CRM Software Developer
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11