[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