Network Blip

[JC3]

Hi

I have created a management DB which basically shows a high level overview of our Call Logging system. This is basically a split DB (FE on users machine and BE on Network). In th FE there are also a couple of ODBC Linked tables from the main DB.

Everything is working fine with this but periodically there seems to be a Network Blip which causes numerous error messages 'object not set' and Disk or Network Error.

I appreciate that this is probably due to the Network experiencing a tiny blip but it kills my DB.

Is there any way to either automatically reconnect the DB or alternatively close the DB cleanly without all the error messages.

Any suggestions?

 

[The_Doc_Man]

The only way I know of to do this is to write OnError trap routines in your event code so that when you get one of these things, you can see the error number. Then and only then could you hope to take corrective action.