[AccessD] Trigger code every day

I'm going to hold your marker on that William.  So far, Widnows Scheduler
seems to be in the lead and it's one less thing I'll have to support in
Shanghai.  I'm in Vancouver for the week anyway and won't really be looking
at this again untilo I get back.

Thanks.

Rocky

Original Message:
-----------------
From: William Hindman wdhindman at dejpolsystems.com
Date: Sun, 13 Aug 2006 18:06:43 -0400
To: accessd at databaseadvisors.com
Subject: Re: [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
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .