Schedule a database

[Guest]

I have created a very simple script to be run from the Windows Scheduler as
per Albert Kallal web site. The code is as follows:

dim accessApp
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase
"K:\SUPPLY\SHARED\All\0MikeShipp\SchedJob.mdb")

accessApp.Run "sDownload"
accessApp.Quit
set accessApp = nothing

The name of the file is download.vbs. It runs fine when I double click on
the icon. However, the scheduler always gives a status of "Could Not Start".
Any ideas would be appreciated.

 

[Pieter Wijnen]

Start it with CScript
CScript /B myscript.vbs

hth

Pieter