I have been looking for solutions to help with improving efficiencies in my workgroup. We have about 45 access databases that get kicked off via Windows Task Scheduler on a daily basis. I would like to try incorporating more rules as to how they kickoff and what they do after kicking off. I am looking at rules that would be based on file modified dates and waiting for files to be updated before moving on to the next database.
I came across this topic and was wondering if Jeff D or anyone else could share their DB that is a Task Scheduler? This sounds like a good solution.