[AccessD] Schedule a Query to run once a month

Susan:

I have a set of queries run every night (or morning...) at 0410 when
nobody is in the database.  I actually have the queries in a separate
application linked to the data (back end).  Then using the scheduler in
windows, have it run the application where the queries are set up to run
in the autoexec macro of the 'different' application.  Then it makes no
difference if the main app is open or not, this one runs when you schedule
it to run.

HTH.

Greg Smith
gregsmith at starband.net


> I have an mdb file that has an update query.  I want this update query
> to run once a month at a specific time. For example, the 28th day of the
> month at 11:00 am.  Is there a way to set this up to run even if the mdb
> file is not open?
>
> --Susan
>
> Susan B. Geller
> Office of Information Systems
> College of Continuing Education
> University of Minnesota
> 306 Wesbrook Hall
> 77 Pleasant Street SE
> Minneapolis, MN 55455
> Phone:  612-626-4785
> Fax:  612-625-2568
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com