Wednesday, January 09, 2013 1:57 AMHow 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.
Wednesday, January 09, 2013 2:38 AM
You should be able to use CreatObject method of VBScript. I'd ask them over here.
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
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"
MS(SPM), MS(E&F), MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
Linked In: http://www.linkedin.com/in/waqasm1
- Edited by Waqas M Wednesday, January 09, 2013 6:22 AM correction