multiple conn? ( resolved)

[Goh]

can i open another connection within an open close conn?

[leinad31]

Reuse a closed connection? Yup you can, just change whatever property needs to be changed and .Open the connection.

[veryjonny]

Originally posted by Goh
can i open another connection within an open close conn?

What do you mean by a open close conn?

[Goh]

wat i mean is within an open conn1(load_form) and close conn1(unload_form) ,in between i open a new conn2 ..is it ok?

[Goh]

or can i reopen a conn (conn1) that is yet to close..?

[leinad31]

Close it first before reopening

[Goh]

then can i : open conn1(load_form) and close conn1(unload_form) in between i open a new conn2 ..is it ok?
ie. 2 different conns..

[leinad31]

if its 2 different connection objects then you can close open them independent of the status of the other.

[Wokawidget]

There is no need for your connection to be constantly open.
Open it, use it, then close it.

In fact your recordsets, you don't even need a connection object.

Private Const CONN_STRING As String = 'your conn string to your DB
 
Dim adoRec As Recordset
   Set adoRec = New Recordset
   With adoRec
      .Open "SELECT * FROM Users", CONN_STRING
 
'blah blah blah