How Recordset close in the vb6

Hi,
How i m know in the project which form has which recordset open. in visualbasic 6.0. i m using vb6 + msAccess
LVL 3
jay_gadhaviAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sivachirravuriConnect With a Mentor Team Lead Commented:
Hi,

Consider "rs" as record set.

rs.state will return you whether it is Open or close
For close it will return 0


'Sample code

Dim rs As New ADODB.Recordset

Private Sub Form_Load()
If rs.State = adStateclosed Then Msgbox "Connection closed"
End Sub
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.