I have 3 asp pages like:

ASPpage1.asp:

'<% dbf_qry = "select * from mytable"
'Set db_rs = CreateObject("ADODB.Recordset")
'db_rs.open dbf_qry, "DSN=mydsn;UID=myid;PWD="
'%>

'
' Display contents of table
'

'<% db_rs.Close %>

'A button is clicked and the page is redirected to ASPpage2.asp - a
'page for data entry

'ASPpage2.asp:

'Contains a submit button and html textboxes, when submit button is
'clicked results are passed on to ASPpage3 for processing

'ASPpage3.asp:

'<% myvar1 = Request.Form("textboxvar")
'myvar2=99.99
'new_qry = "Insert into cmts_unit_invty values(" & "'" & myvar1 & _
' "'," & myvar2 & ")"
'set new_rs = server.CreateObject("ADODB.Recordset")
'new_rs.Open new_qry,"DSN=mydsn;UID=myid;PWD="
'new_rs.Close
'Response.Redirect("ASPpage1.asp")
'%>

I get the error message:

The operation requested by the application is not allowed if the object is closed.

Why is this and how can i solve this problem? Thanks for any solutions/suggestions.

Carlos

P.S. actual code is w/o comment delimiters