[AccessD] Suitability of Access For Task

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