MS Access running a macro (scheduled task) without user intervention.
==========================
"E:\Program Files\Microsoft Office\OFFICE11\msaccess.e
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This does PART of what im looking for by bypassing the prompt you get for macro security.
But it still opens up access and runs the macro visually.
I want this to be done silently.
Really appreciate your help.