What's the difference between the two?

toptime

dim rs as new adodb.recordset

What is the difference between rs.close and set rs = nothing?

yflovefly

rs.close about connection
set rs = nothing destroy object

toptime

Are their effects the same?

madwww

Different.

The rs.close object still exists, you can continue to use it.

The set rs = nothing object no longer exists. If you want to use it, you need to recreate it (set rs = new adodb.recordset).

toptime

I see ... thanks upstairs ...

toptime

Ask again, if defined in a private process
such as
Public Sub tab_save ()
    Dim rs_save As New ADODB.Recordset
    Dim db_save As New ADODB.Connection
    Dim connectionstring As String
    Dim sqlstring As String
    connectionstring = "provider = Microsoft.Jet.oledb.4.0; data source ="&dbname
    db_save.Open connectionstring '------------------------------- connect to adodb database
...
    Set rs_save = Nothing
    Set db_save = Nothing
End Sub

So is it right?
    Set rs_save = Nothing
    Set db_save = Nothing
Is it the same whether you write or not?