Re: run an Access query from windows scheduler
- From: "david epsom dot com dot au" <david@epsomdotcomdotau>
- Date: Fri, 31 Mar 2006 10:48:45 +1000
Here is a vb script example using the Windows Scripting host:
dim dbe
dim db
set dbe = wscript.createobject("dao.dbengine.36")
set db = dbe.OpenDatabase("c:\dev9.mdb")
db.Execute "qryBAI_2232_Match_tmp_Cheque", 512 or 128
wscript.quit
(david)
"sumGirl" <nix.david@xxxxxxxxx> wrote in message
news:1143732415.087992.188920@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is it possible to run an access query from the scheduler? I need to
update a table in the middle of the night, and so I would like to set
up a job on a machine thats on all night so I dont have to manually do
it.
.
- References:
- run an Access query from windows scheduler
- From: sumGirl
- run an Access query from windows scheduler
- Prev by Date: Re: Trouble with DAO "SEEK" in converting application to SQL Express back end.
- Next by Date: Re: if table exist
- Previous by thread: Re: run an Access query from windows scheduler
- Next by thread: Using windows dialog box
- Index(es):
Relevant Pages
|
|
