Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
Opening a MS Access 2010 database using Windows Server 2008 R2 task scheduler

Răspuns Opening a MS Access 2010 database using Windows Server 2008 R2 task scheduler

  • Wednesday, January 09, 2013 1:57 AM
     
     
    Sign In to Vote
    0
    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

     

All Replies

  • Wednesday, January 09, 2013 2:38 AM
     
     Answered
    Sign In to Vote
    0

    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 6:20 AM
     
     
    Sign In to Vote
    0

    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
    •