understand a closed object conn

[sal21]

I i use a conn similar:

...
Set CONN = New ADODB.Connection
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\....
...

i need to use:

conn.close
set conn=nothing

to the and of code, or the satatement Set CONN = New ADODB.Connection automaticlly destroyed all conn object???

note:
i use the conn recursivlly

[HansV]

You should close the connection before opening a new one, but if you use Set conn = New ADODB.Connection, you don't need to use Set Conn = Nothing before that. So either use

conn.Close
Set conn = Nothing

when you don't need conn any more, or

conn.Close
Set conn = New ADODB.Connection

when you want to create a new connection.

[sal21]

You should close the connection before opening a new one, but if you use Set conn = New ADODB.Connection, you don't need to use Set Conn = Nothing before that. So either use

conn.Close
Set conn = Nothing

when you don't need conn any more, or

conn.Close
Set conn = New ADODB.Connection

when you want to create a new connection.

now all is clear!
tks.