none
Opening a MS Access 2010 database using Windows Server 2008 R2 task scheduler

    Question

  • How can I open a MS Access 2010 database and run a macro or stored procedure using the task scheduler in Windows Server 2008 R2? The Access database that I need to open is on another server.

    ug3j

    Wednesday, January 09, 2013 1:57 AM

Answers

All replies

  • You should be able to use CreatObject method of VBScript. I'd ask them over here.

    http://social.technet.microsoft.com/Forums/en-US/ITCG/threads

    http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

    http://answers.microsoft.com/en-us/office/forum/access?tm=1357699092034

    Also

    http://support.microsoft.com/kb/209207

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, January 09, 2013 2:38 AM
  • Hi,

    First try and run the Acess macro from  command prompt using example

    "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "C:\Scripts\accessfile.accdb" /x macroName

    where "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" is your access .exe path

    and "C:\Scripts\accessfile.accdb" is access file path

    Then you have to create a job in task scheduler to run following command.

    C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "C:\Scripts\accessfile.accdb" /x macroName

    For configuring the task to run with the built-in local System account or user account with permissions.  



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F), MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @waqas8777
    Linked In: http://www.linkedin.com/in/waqasm1


    • Edited by Waqas M Wednesday, January 09, 2013 6:22 AM correction
    Wednesday, January 09, 2013 6:20 AM