Liz Doering
liz at symphonyinfo.com
Mon Nov 22 09:57:26 CST 2004
Susan, Use Windows Scheduler to open the .mdb with the update query. Set up an autoexec macro to run a function that checks the date and time, then runs the query if the current date and time are when you want it to run. It's been ages since we've heard from you! Hope all is well. Liz Doering Symphony Information Services liz at symphonyinfo.com www.symphonyinfo.com 763-391-7400 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Geller Sent: Monday, November 22, 2004 9: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