Master Control Program

[PiedPiper70]

Can't quite get my head around this. I have a series of 7 separate Access 2010 programs that are designed to run under the control of a scheduler, and they must always finish. Errors are trapped and logged but mustn't stop the processes completing.

What I'm trying to do now is to create a single master control program that runs each individual application, one after the other, in order. And each individual app cannot start until the previous one is finished.

I don't understand how to call a separate Access program and know when it has finished. Can anyone help out please?

Thanks very much

 

[llkhoutx]

There's a free program, AutoIT, which will do what you want.

 

[PiedPiper70]

Thanks Ilkhoutx, I'll look out for it.

But I have solved my problem with some code from Microsoft and it's working fine. Here's the link:
http://msdn.microsoft.com/en-us/library/office/ff845544(v=office.15).aspx