Mark A Matte
markamatte at hotmail.com
Tue Mar 6 13:41:34 CST 2007
Larry, I have an A2K db that also runs 24/7/356...it checks an FTP site every 5 minutes...if there are files...downloads...clears FTP site...analyzes data...and sends email. I have NOT built an AUTO Archive yet...so about once every 3 months I manually archive and compact. Other than that...I have had no issues. Good Luck, Mark A. Matte >From: "McGillivray, Don [IT]" <Donald.A.McGillivray at sprint.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Suitability of Access For Task >Date: Tue, 6 Mar 2007 13:08:54 -0600 > >Larry, > >FWIW, I have an app that basically runs unattended 24/7/356. It runs in a >terminal service session on a remote server, and monitors the status of >several directories on several servers and manages and summarizes the >contents of files that it finds there. It's designed to ignore, retry, >and/or send alarms if network difficulties prevent access to the various >target servers. Otherwise, it stops only when I bring it down for >maintenance/upgrade, etc.. It gives me danged few problems running in this >way. > >HTH, > >Don > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek >Sent: Tuesday, March 06, 2007 10:29 AM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] Suitability of Access For Task > >Thanks John: > >On your app, does Access basically stay "on" all of the time, or do you >schedule it to also close and reopen? I've had server apps that open at >specified times, run a process, then close ... Those have worked quite well >for me. > >Basically, just worried about the application timing out or freezing on me. > >Any recommendations on barcoding add-ins for Access? > >Larry Mrazek >LCM Research, Inc. >www.lcm-res.com >lmrazek at lcm-res.com >ph. 314-432-5886 >mobile: 314-496-1645 > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby >Sent: Tuesday, March 06, 2007 11:56 AM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] Suitability of Access For Task > >I don't see anything there that is not doable in Access. I run Access on a >server where it does this type of monitoring. > > >John W. Colby >Colby Consulting >www.ColbyConsulting.com > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek >Sent: Tuesday, March 06, 2007 12:24 PM >To: 'Access Developers discussion and problem solving' >Subject: [AccessD] Suitability of Access For Task > >Hi Folks: > >I have a possible project that will need to: > >1. Monitor a dbase table for changes, when a certain event is seen, read an >ID number and print it in EAN128 barcode format. >2. Monitor another dbase table for a specific event, then write an ID >number >to a temp table. >3. Scan the barcode from #1 and compare it the ID number from #2 ... If >they >match, write success codes to a table, if they don't, display error and >write info to a table. > >Given that this app will have to be running 12-18 hrs per day; it will >usually have to deal with 30-50 of these events per day, should I be >looking >to write it in VB.NET? > > > >Larry Mrazek >LCM Research, Inc. >www.lcm-res.com >lmrazek at lcm-res.com >ph. 314-432-5886 >mobile: 314-496-1645 > > > > >-- >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 _________________________________________________________________ Find a local pizza place, movie theater, and more….then map the best route! http://maps.live.com/?icid=hmtag1&FORM=MGAC01