We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

MS Access running a macro (scheduled task) without user intervention.

Simon336697
Simon336697 asked
on
Medium Priority
799 Views
Last Modified: 2012-05-06

=================================== importcomputers.bat
"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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
from access window
tools > macro>security
set the security to Low

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Commented:
Set the macro security to low

Author

Commented:
Hi capricorn thank you mate.
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.
Rather than running as a BAT file you need to run the command directly from the Task Scheduler, this way you have the option of running it as Hidden.
Cheers, Andrew
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.