I have Windows XP Prof. SP2 and have used the scheduled task utility to open a MS access based utility/application every morning at a set time. The Access utility has some VBA code that processes some data and then generates some reports. The problem is that the utility never completes running all the processes. I decided to split the tasks into three modules and run 3 utilities together but still none of the three completes the processes.
If I run the process manually everything runs successfully without any problems. Does anyone know how to resolve this issue? I appreciate all your help.