run Access query with windows job scheduler

S

sumGirl

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.
 
M

Martin J

In your autoexec run a function like this
....
If time > #9:00:00 PM# Then do queries
....
Then just open your database normally with scheduler at the right time and
it will run.
 
Top