run Access query with windows job scheduler

  • Thread starter Thread starter sumGirl
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

task schedule to run MS Access 4
Facebook problem on Windows 1
Access Dcount (multiple criteria) 3
scheduled tasks / cron jobs under Vista 7
entering the end of the time for scheduled job 0
as records added(jobs sched)-#days from est. days 5
Update Query from Excel VBA module 2
Run a VBA Sub using Windows Scheduler? 5

Back
Top