[AccessD] Trigger code every day

The app creates the files.  The app is actually my E-Z-MRP system and 
the third party is a company called Healex which makes a product called 
Nocturne.  On a regular basis, in this case daily, the client exports 
files (from whatever manufacturing management system they're using, in 
this case mine) containing their parts, inventory, purchase orders, 
unmet demands, transactions, supplier info, etc. and the Nocturne 
program picks the data off of their server and passes it out to the 
suppliers who get daily updates on what their customer needs in the way 
of raw materials. It's a supply chain management thing. 

And generally it's used by really big companies.  This outfit in 
Shanghai is real small - small enough for E-Z-MRP, but their only 
customer is Phillips - who uses Nocturne themselves.  So Phillips 
insisted that this little company, a captive supplier, use Nocturne as 
well. 

So I wrote a routine inside E-Z-MRP to create these csv files for 
Nocturne and they could trigger the export whenever they wanted.  But of 
course, once they saw how it worked, next thing they wanted was for it 
to be automated to run every day so they wouldn't have to remember to do it.

So there's more than you probably wanted to know.


Rocky


Charlotte Foust wrote:
> The answer is "it depends."  We created a couple of products that run
> like this.  The big gotcha is that it doesn't run as a service, and it
> really isn't a good idea to install Access on a server.  Yes, it sucks
> up cycles, not to mention the fact that when the server goes down, it
> will come back up but your application won't.  The better way is not to
> use Access for the app. 
>
> When you say the app is going to "export some files",  what do you mean?
> Are these files created by the app or by some other application, with
> the desired program just checking for the existence of files and then
> moving them somewhere?
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> - Beach Access Software
> Sent: Thursday, August 10, 2006 9:09 AM
> To: Access Developers discussion and problem solving
> 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