Object already open ? Can I know before !!

[sarah77]

Program error says "object already open" when it reach the statement :

De.RsPc.Open

De is related to the Data environment
RsPc related to a table

Is there a way to know if RsPc is opened or not such as
( if De.RsPc.Open=True )... any comment ?

(VB6)

Thanks

 

[NipsMG]

I'm not POSITIVE what you're doing, but if RsPc is an ADO Recordset Object, then..

If De.RsPc.State = adStateOpen then De.RsPc.Close

--NipsMG s-)