Run a query automatically every day

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

Guest

All,

I have a pass-through query to get some data into my database from the
server. I would like to have this data refreshed once a day. Can anyone help
me with it...I mean to run the pass-through query automatically in a
specified time? Any help would be highly appreciated. Thanks!
 
Set up Windows Task Manager to open Access and run your query at the
specified time.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Set up Windows Task Manager to open Access and run your query at the
specified time.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)







- Show quoted text -
Click to expand...

Steve,

As PC Datasheet has said, using the Windows Task Scheduler is a good
solution. However, to use this you will also need to create a macro
that will run the query and then close the database. If you need to
do other things, you can create a function in a module and have your
macro run that code. Name this macro "AutoExec". When your database
is opened, by the Windows Task Scheduler, your "AutoExec" macor will
be automatically run.

Hope this helps.

Mr. B
 
Back
Top