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

Posted on 2009-02-09
Medium Priority
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.
Question by:Simon336697
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 660 total points
ID: 23595379
from access window
tools > macro>security
set the security to Low
LVL 18

Assisted Solution

jmoss111 earned 660 total points
ID: 23595434
Set the macro security to low

Author Comment

ID: 23595450
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.
LVL 28

Accepted Solution

TextReport earned 680 total points
ID: 23598255
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

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question