Suppressing ODBC pop up error "janefield2002[ at ]yahoo.com" <janefield2002[ at ]yahoo.com> 6/16/2007 4:05:21 AM 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!

Re: Suppressing ODBC pop up error Andrew Rossmann <andysnewsreply[ at ]no_junk.comcast.net> 6/16/2007 3:10:15 PM [This followup was posted to microsoft.public.win2000.general and a copy was sent to the cited author.] In article <1181966721.555233.133070[ at ]j4g2000prf.googlegroups.com>, janefield2002[ at ]yahoo.com says... [Quoted Text] > 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

Re: Suppressing ODBC pop up error "Dave Patrick" <DSPatrick[ at ]nospam.gmail.com> 6/17/2007 1:39:21 AM Yes, test for connection and act accordingly inside your vb6 app. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect <janefield2002[ at ]yahoo.com> wrote: [Quoted Text] > 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! >