Access Database Scheduled Task
Posted on 2013-10-23
I'm currently working with Scheduled Tasks built to run a macro within our Access Databases. The trouble that comes about, is that seemingly at random, the task will simply not work, and the server is left with two instances of "msaccess.exe" running in the background.
The BATCH files I'm targeting with my tasks are something to the effect of...
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\Program Files\Microsoft Office\Office\samples\northwind.mdb" /Excl /X Add Products
*Note* The above is taken directly from M$'s website, and my macro is almost identical.
Running the task from within windows works like a charm, and the macro goes off without a hitch. On the other hand, letting it run over night as it's intended to seems to fail 50% of the time, if not more.
Has anyone experienced anything like this, or found a good work around?