[AccessD] Schedule a Query to run once a month

Arthur Fuller artful at rogers.com
Mon Nov 22 20:09:29 CST 2004


I could be wrong, since I have never done this, but I'll take a WAG. 
Create a shortcut to the specific query, then schedule its execution 
using the Scheduler.

Arthur

Joe Hecht wrote:

>Based on other discussions in this group, you need to have some program or
>operating system scheduled event to call the mdb.
>
>Joe Hecht
>jmhla at earthlink.net
>28g
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Geller
>Sent: Monday, November 22, 2004 7:41 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Schedule a Query to run once a month
>
>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
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.1 - Release Date: 11/19/2004




More information about the AccessD mailing list