Hi Alvin,
I think I know what you mean.
I use this bit of code on the bottom of my page to close the RecordSet If Open and the DataBase Connection If Open. Seems to work well.
If objRS.State Then
objRS.Close
Set objRS = Nothing
End If
If objConn.State Then
objConn.Close
Set objConn = Nothing
End If
Hope This Help.
Kind Regards,
Tarran Walker