[AccessD] Trigger code every day

Rocky

...I have a pretty simple program that does this that's been in production 
service since 2000 for a client ...it runs as a separate fe app on a 
dedicated work station and links to your be tables ...I can post a copy for 
dl if you'd like.

...but if I were doing it today from scratch I'd take a hard look at using 
FMS's Total Access Agent which will run as an NT Service and execute your 
exports in the background without other users even being aware anything is 
happening ...the advantages of such a program running as a service are 
significant but in short, it automatically restarts with every reboot and 
does not have the user or security vulnerabilities/problems that the Task 
Scheduler has, imnsho ...hth.

William

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, August 10, 2006 12:09 PM
Subject: [AccessD] Trigger code every day


> Dear List:
>
> A client needs to run a program every day at the same time to export
> some files.  I'm thinking that I use the OnTimer event with some timer
> interval (like 5 minutes) and check the clock to see if it's time to do
> the export.  This app will run all the time in the background and reside
> probably on their server.  Is this going to suck up a lot of server
> cycles?  Is there a better way to do this?
>
> MTIA
>
> Rocky
>
> -- 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>