[dba-Tech] re-acquiring network connectivity

[Gustav Brock]

Hi Mike

If it stops with a "Disk or Network error" your application is hosed.

There is no workaround for this, so you will have to ask the "notwork guy" to fix the LAN (or rather the switches) for example by configuring Quality-of-Service so at least some bandwidth will be left to service your sweep PC.

If the floor PCs are connected via WiFi, you are in trouble as it is almost impossible to guarantee no glitches. However, with the most modern Access Points from one of the top vendors you can come close.

/gustav

-----Oprindelig meddelelse-----
Fra: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] På vegne af Zimmer, Michael
Sendt: 21. marts 2016 15:16
Til: Discussion of Hardware and Software issues <dba-tech at databaseadvisors.com>
Emne: [dba-Tech] re-acquiring network connectivity

Good morning all,

I have a question for the community:

Currently we (at work) are using a MS Access 2007 database as a "sweep" PC which periodically collects data from 17 PCs running on the shop floor.
This sweep PC is connected to the network via Ethernet, however, it seems particularly vulnerable to the little network connectivity "glitches" we experience here.

For example, I came in today and sometime over the weekend there was a momentary loss of network and the sweep database stopped collecting and had to be manually re-started.  Now it is running its access VB code and picking up 3000 records.

Does anyone have a good way for a database to re-acquire the network after a brief outage? This database needs to run unattended.

Thanks,

Mike Zimmer