Suppressing ODBC pop up error

[janefield2002]

Hi there,

I have a client-server application that periodically connects to an
Access database on a network. My netowrk sometimes goes down and there
is an ODBC failure to connect. This results in an ODBC error pop up
window. I am interested in suppressing this pop up, catching the
exception and simply saying "network is down" or something like that.

Is this possible? How is this done? My application is VB 6.

Thanks!

[Andrew Rossmann]

[This followup was posted to microsoft.public.win2000.general and a copy
was sent to the cited author.]

In article <11**********************@j4g2000prf.googlegroups. com>,
ja***********@yahoo.com says...

Hi there,

I have a client-server application that periodically connects to an
Access database on a network. My netowrk sometimes goes down and there
is an ODBC failure to connect. This results in an ODBC error pop up
window. I am interested in suppressing this pop up, catching the
exception and simply saying "network is down" or something like that.

Is this possible? How is this done? My application is VB 6.

In the areas where you connect, use ON ERROR GOTO xxxx, or put the
connection routines inside a Try...Except section.

--
If there is a no_junk in my address, please REMOVE it before replying!
All junk mail senders will be prosecuted to the fullest extent of the
law!!
http://home.att.net/~andyross