Hi,
I have doubt in disconnected recordset,after retriving the Rows from Table and i set rs.activeconnection=nothing after that whether we can insert/update records in to the Table by re-establishing the connection??????

If you close your connection, no you can not. Why close your connection if you havnt finished with it? I open a connection in the head of my page, do transactions where neccessary then close it in the foot (make sure you do close connections)

BTW: If you are going to use records multiple times on a page and do not need to execute any further queries, you can
1. Open RS
2. RS.getRows() (put into array)
3. Set Rs = nothing
4. conn.close() (close connection)
5 Set conn = nothing

Wind is your friend
Matt