Results 1 to 2 of 2
  1. #1
    btidwell3 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    13

    Exclamation Running Access from a Scheduler

    To All,

    I have several extractions that run overnight on a server, using Access 2010 32 bit. I am calling macros using the command line, being initiated by the Windows Task Scheduler.

    I have not been able to come up with a way to close the Access app when the extraction process completes. I have tried using the "Application.Quit" command from the VBA code, I have tried running the "Quit" command from the called macro. I have also tried running a batch file containing, "Taskkill /f /im msaccess.exe* /T". Nothing works reliably, except having a human being run the Task Manager each morning and closing several instances of "msaccess.exe" on the "Processes" tab, manually.

    It seems to be that this should be something easy to do. We are running Windows Server 08 as the OS on the server.

    Has anyone else dealt with this issue? Is there a good solution?

    Thanks in advance for the help.

    Sincerely,

    Bill

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    This is my VBScript called by Scheduler.

    Dim accessApp
    set accessApp = CreateObject("Access.Application")
    accessApp.OpenCurrentDataBase("your path/filename here")
    accessApp.Run "your procedure name here"
    accessApp.Quit
    set accessApp = nothing
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Crew Scheduler
    By dbradymusic in forum Database Design
    Replies: 1
    Last Post: 10-22-2013, 07:47 PM
  2. Appointment scheduler
    By cheyanne in forum Forms
    Replies: 1
    Last Post: 06-03-2012, 07:29 AM
  3. Windows 7 scheduler
    By faeren in forum Misc
    Replies: 1
    Last Post: 01-27-2012, 10:26 AM
  4. Database Scheduler
    By jgelpi16 in forum Access
    Replies: 4
    Last Post: 06-01-2010, 10:15 AM
  5. Access Scheduler
    By Chockness in forum Access
    Replies: 0
    Last Post: 03-31-2010, 11:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums