Automate periodically running a access97 action i.e data loading macro 2

[jn1971]

Hi Gurus,
I create a access97 macro that will perfrom a task of loading data from a remote server. I would like to automate this macro to perform the task every 4hrs w/o human control. Is it possible to use VB to establish this automated task. Any help/codes is greatly appreciated. Jeanie

 

[SkyHigh]

There is a free utility call Hall at

http://www.geocities.com/waddly/accory.html#Hal

which will do that for you.
Have fun!

 

[scriverb]

Wow, I was going to suggest how to do it herself by use of an invisible form that stays open all the time and runs routines by monitoring a table from within the TimerEvent procedure. But, you have posted a very nice link her that I have downloaded and will be using for sure in the future. Nice posting. Have a Star for this one. Hopefully many here at TT will see this thread and benefit.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[jn1971]

Hi SkyHigh,

Thank you very much for the link. I have not worked on it yet but I think thats what I look for. I also thank Bob Scriver for having a thought of my problem. Thanks very much and have a great weekend. Jeanie