By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,259 Members | 1,708 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,259 IT Pros & Developers. It's quick & easy.

How Do I Set a Query to Run Every Hour?

P: n/a
I have an A97 db on Win2k machine. I have a make table query to
update a small db wich we then FTP to our website for customer order
status.

What is the best way to automate the query to run once per hour? (I
made a macro to run the query, but it seems that Windows Scheduler
will only run once per day.) It would be really neat if I could have
Access97 actually FTP the new db every hour.

Thanks,

Brooks
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Sat, 04 Dec 2004 15:41:36 GMT, bc******@midsouthcolor.com (Brooks
Clayton) wrote:

You could create 24 tasks.
Or have your app run all the time with a timer behind a form. At each
timer tick, check if a new hour has started, and if yes, do your thing
and set the hour to 'completed'.

-Tom.

I have an A97 db on Win2k machine. I have a make table query to
update a small db wich we then FTP to our website for customer order
status.

What is the best way to automate the query to run once per hour? (I
made a macro to run the query, but it seems that Windows Scheduler
will only run once per day.) It would be really neat if I could have
Access97 actually FTP the new db every hour.

Thanks,

Brooks


Nov 13 '05 #2

P: n/a
"Brooks Clayton" <bc******@midsouthcolor.com> wrote in message
news:41**************@news.networktel.net...
I have an A97 db on Win2k machine. I have a make table query to
update a small db wich we then FTP to our website for customer order
status.

What is the best way to automate the query to run once per hour? (I
made a macro to run the query, but it seems that Windows Scheduler
will only run once per day.) It would be really neat if I could have
Access97 actually FTP the new db every hour.


Which version of Windows? Scheduler should be able to run as often as you want.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

P: n/a
I am running Windows 2000 Professional. I do not see an option for a
frequency greater than once a day.

Brooks
On Sat, 4 Dec 2004 10:30:02 -0600, "Rick Brandt"
<ri*********@hotmail.com> wrote:
"Brooks Clayton" <bc******@midsouthcolor.com> wrote in message
news:41**************@news.networktel.net...
I have an A97 db on Win2k machine. I have a make table query to
update a small db wich we then FTP to our website for customer order
status.

What is the best way to automate the query to run once per hour? (I
made a macro to run the query, but it seems that Windows Scheduler
will only run once per day.) It would be really neat if I could have
Access97 actually FTP the new db every hour.


Which version of Windows? Scheduler should be able to run as often as you want.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #4

P: n/a
I just checked with Windows XP, you'll find in the advanced properties
of the scheduled task an option to run hourly. You must create the
task first in order to see the advanced properties.
Windows 2000 should be the same.

Nov 13 '05 #5

P: n/a
Thank you. You are correct, it is in W2k, I just did not get far
enough into the process.

Brooks
On 4 Dec 2004 09:42:07 -0800, st*******@yahoo.com wrote:
I just checked with Windows XP, you'll find in the advanced properties
of the scheduled task an option to run hourly. You must create the
task first in order to see the advanced properties.
Windows 2000 should be the same.


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.