ADO - rs.Close or set rs=nothing

[kovan]

ADO - rs.Close or set rs=nothing

which one is better?

if i set RS = Nothing do i have to
put

 Set RS = New ADODB.Recordset

before i can use this record again?

thanks

[Stevie]

I always use both when closing ...

rs.Close
set rs = Nothing

I also always "set rs = new adodb.recordset" when re-using a recordset.

[Ianpbaker]

Hi again kovan

Yes if you set it to nothing you have to re-set it.

if you need to use the recordset again, use rs.close and when you come to terminate your app, then set it to nothing

Ian

[Gary.Lowe]

Kovan

i found this useful to close recordsets without erros

    If Not rstTemp Is Nothing Then
        rstTemp.Close
        Set rstTemp = Nothing
    End If

I f I have any recordsets in a project I just create a function with the above for each recordset, database, workspace, then I know every thing has been closed properly.