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.
Actually, I'm having trouble with task scheduler too. Basically, you have to create a script that does what you want. If you get it to work manually, try to add it to the task scheduler. How do you know when a politician is lying? His mouth is moving.
Create a simple script and schedule it. How to use command-line switches in Microsoft Access
Keep in mind though that scheduled tasks execute on Session 0 so you won't be able to see any GUI pop up, or be able to interact with it.
Tony
