MS Access running a macro (scheduled task) without user intervention.
Posted on 2009-02-09
"E:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "e:\test\mydb_test.mdb" /x Nightly
The above is a script that runs a macro called Nightly.
It works fine but with only one problem.
When it fires as a scheduled task, it opens up msaccess and prompts me with a macro security warning.
Instead of this, id like the task to run silently so that i dont have any prompting whatsoever, and it opens msaccess, runs the macro etc without any intervention.
Any help greatly appreciated.