How to run a Query at specific hour??

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

Guest

Someone knows how do this:??
1.- Start Access at specific time lets say 20:00
2.- Run a make table query
3.- Exit Access

I was looking for OnTime event such as is in Excel with no success, can
someone give a clue??
 
Hi,

Try this

1) Write a mdb that on startup runs a from.
2) In on open run the query in vba
3) on the oncurrent event quit the database.

This should run your task whenever you want. (This is all the database does)

To run it at a specific time do following.

Look at system tools in programs of windows and run schedule tasks to open
your file at a time requested.

Hope this helps

Trev
 
Back
Top