Schedule a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top