View Poll Results: Do other dbforum members use the task scheduler frequently

1. You may not vote on this poll
  • Yes

    0 0%
  • No

    1 100.00%
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012

    Unanswered: Windows 2008 Task Sceduler and Access 2012

    I have some new 2008 servers. I have sceduled MSACCESS as task with autorun macros etc in the past on 2003... The syntax in the task Actions screen are not the same. Does anyone have a good resource for new syntax.

    formerly in the 2003 task scheduler I had in Task tab under Run:
    "C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft Office\Microsoft Office Access 2007.lnk" C:\Batch\DBWORKORDERS.accdb

    and in Start in I had:
    "C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft Office"

    The new task sceduler we have an Actions tab with an Edit Action window:

    Action options: I selected "Start a Program" from the drop down as that is the only option. duh!

    1) Program/script:

    2) Add arguments (optional)

    3) Start in (optional)

    Your direction would be greatly appriciated.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Create a batch file (.bat or .cmd) containing the necessary commands and parameters to have Access open the desired database, and call that file from the scheduler.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts