Denise;

Hope this helps. I do not know what you have done for a connection object, etc., but here is how I do it. objRS is my recordset object, and objConn is my connection object.

objRS.close
set objRS = nothing
objConn.close
obj.Conn = nothing

Tom