Scheduled task on windows server (1 Viewer)

[TDZ7200]

Hello

I have a vbs-script that opens my access database db.mdb and runs the module "Export":

dim accessApp
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("D:\Data\db.mdb")
accessApp.Run "Export"

accessApp.Quit
set accessApp = nothing

This works fine as a scheduled task on a Windows 7 computer.

Is there a way to make this work on a Windows Server 2008 R2 ? When I double click the vbs-file, the file opens instead of runs. And when I create a scheduled task, nothings happens.

Any help is wellcome. Manu thanks in advance.

 

[Rx_]

http://www.access-programmers.co.uk/forums/showthread.php?t=276605
I had posted something like this on the Windows blog, but have not had any answers.
This is something on my schedule in about 2 weeks.
Please take a look at it.
And please be sure to post any success, failures, or suggestions.

 

[TDZ7200]

What worked for me, was splitting everything in two steps : I made a batch file which calls the vbs-script. In windows 7, this split is not required : you can run the vbs-script directly in the task scheduler.