How to run a Query at specific hour??

R

RicardoLH

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??
 
T

Trever B

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
 
Top