Hi Jim, I stand corrected. On looking at the MSDN help, it only lists adStateOpen and adStateClosed as valid values for a Connection object. However, the same named constants can be used for Command and Recordset objects, as well as Connection objects. David Lant I.T. Consultant Consultancy & Development ICT Services Tel: (01392) 382464 Devon County Council accepts no legal responsibility for the contents of this message. The views expressed do not reflect those of Devon County Council. -----Original Message----- From: Corbett, James [mailto:James.Corbett@xxxxxxxxxxxxxxx] Sent: 06 September 2005 17:39 To: 'program-l@xxxxxxxxxxxxx' Subject: [program-l] Re: VB6: Connection Object David: I think you are refering to the Recordset object in your example. I have just read the help on the State property but the example with in is centered on the Recordset. I am looking for the state of the AODB object its self. The recordset object is a child of this parent. Jim -----Original Message----- From: David Lant [mailto:david.lant@xxxxxxxxxxxx] Sent: September 6, 2005 12:08 PM To: 'program-l@xxxxxxxxxxxxx' Subject: [program-l] Re: VB6: Connection Object Hi Jim, One would have thought that it checks the actual connection to the database, as you can use it not only to find out if the connection is open or closed, but what it is actually doing at the time. E.g. you can compare the State property against the adStateOpen, adStateClosed, adStateExecuting, adStateFetching and adStateConnecting constants. David Lant I.T. Consultant Consultancy & Development ICT Services Tel: (01392) 382464 Devon County Council accepts no legal responsibility for the contents of this message. The views expressed do not reflect those of Devon County Council. -----Original Message----- From: Corbett, James [mailto:James.Corbett@xxxxxxxxxxxxxxx] Sent: 06 September 2005 16:56 To: Program-L (E-mail) Subject: [program-l] VB6: Connection Object Hello all: I have the need to frequently check my ADO Connection object for viability. If I use the Object.State property does that actually check the connection to the database or simply the existance of the object in memory? Jim James M. Corbett (613) 941-8303 | facsimile / télécopieur 613 941-8720 | TTY/ATS 1-800-665-0354 James.Corbett@xxxxxxxxxxxxxxx IT Programmer/Analyst | GST/HST Division | Information Technology Branch Programmeur/Analyste en technologie de l'information | Division de la TPS/TVH | Direction générale de l'informatique Canada Revenue Agency | 875 Heron Rd., Ottawa, ON K1A 0L5 Agence du revenu du Canada | 875 Ch. Heron, Ottawa ON K1A 0L5 Government of Canada | Gouvernement du Canada "The following Ha Ha is not for amusement, but an expression of contempt... Ha Ha!" Nelson Mudge Now this is not the end. It is not even the beginning of the end. but it is, perhaps, the end of the beginning." Winston Churchill ** To leave the list, click on the immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** program-l-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** program-l-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** program-l-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** program-l-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** program-l-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** program-l-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** program-l-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** program-l-request@xxxxxxxxxxxxx with the Subject:- faq