You can use a bat file..and go:
start "c:\path name to file\mydb.mdb"
You should ensure that the mdb starts...runs whatever...and the shuts down.
You need to test this.
Did I say you need to test this?
However, in place of a bat file, you best use a windows script.
Just paste the folwling into a standard notepad.txt
dim accessApp
msgbox "Click ok to run batch job",64
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("C:\Documents and Settings\Albert\My
Documents\Access\ScriptExample\MultiSelect.mdb")
accessApp.Run "TimeUpDate"
accessApp.Quit
set accessApp = nothing
msgbox "Job complete", 64
Now, save the file..and then re-name the .txt extension to .vbs. note
how the icon for the file changes. Congratulation...you just written your
first
windows script.
The above script when clicked on will now run. It actually executes a sub
call "TimeUpDate" that exists in a standard code module...and then now how
it shuts down (quits).
If you going to put the above script into the scheduler...then of course
remove the msgbox commands.....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com