[AccessD] Trigger code every day

Rocky,
I understand its just the export of then existing files.
In this case you can use Karen's Replicator
http://www.karenware.com/powertools/ptreplicator.asp
its free and you can schedule it as you like.
I'm using it to copy files within my network on a regular basis.

Lembit

----- 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: Friday, August 11, 2006 1:44 AM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.10.9/416 - Release Date: 10.08.2006
>
>