[dba-Tech] re-acquiring network connectivity

[Gary Kjos]

Does the database reside on a network drive?  Is is split front end
and back end?

I am wondering if you had a local front end connected to a network
backend and then in between it's sweeps if it could be disconnected
and then reconnect prior to the next sweep process, do it's thing and
then disconnect to the back end which would reside on the network.
If it wasn't able to reconnect an error would come up.  You could then
wait a while and try again.

On Mon, Mar 21, 2016 at 9:16 AM, Zimmer, Michael
<Michael.Zimmer at federalmogul.com> wrote:
> 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
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com