Colby, John
JColby at dispec.com
Mon Nov 22 09:57:10 CST 2004
You have to use Window's scheduler to open the database and execute the query. I would place the query out in a separate MDB, link in all and only the tables required for the query, then write a little function to run the query then shut down the db again. John W. Colby The DIS Database Guy -----Original Message----- From: Susan Geller [mailto:sgeller at cce.umn.edu] Sent: Monday, November 22, 2004 10: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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com