This is some simple code, but why the error??<BR><BR>DBConn = Session("DBConn")<BR>strSQL= "SELECT * FROM table"<BR>Set oRS = Server.CreateObject("ADODB.RecordSet")<BR>oRS.Open "table", DBConn<BR>Set oRS= DBConn.Execute(strSQL)<BR>oRS.Close<BR>Set oRS = nothing<BR><BR>And this is the error...<BR><BR>-ADODB.Recordset error &#039 800a0e78&#039 <BR>-The operation requested by the application is not allowed if the object is closed. (oRS.Close is the line referenced)<BR><BR>I know closing recordsets is very NB, but when it does this, it&#039s easy to leave it out!<BR><BR>Thanks<BR>Derek<BR><BR>