Run query at a scheduled time

Question

i have two queries in my database. i am willling to automate it as the query runs at 9 am every day

my database name is pooja

query name is bep2 and bep3

---

I am a System Administrator at Vadodara

Answer 1

Create a macro that run each of your queries.  Then create a scheduled task that use the /x command line switch (http://support.microsoft.com/kb/209207) to run each of the queries.

---

Daniel Pineault, 2010-2012 Microsoft MVP
http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

You need to develop your MS Access project, with this:

docmd.RunMacro "AutoExec"

Run the .exe using the Windows Task Scheduler.  How you develop your project is totally up to you.  See the links below for an illustrated tutorial on how to use the Windows Task Scheduler.

Windows XP:

http://www.iopus.com/guides/winscheduler.htm

Windows 7:

http://windows.microsoft.com/en-US/windows7/schedule-a-task

Please see this for more info:

http://support.microsoft.com/kb/230575?wa=wsignin1.0

---

Ryan Shuell