My OS is windows 2000 (not server). Database is Access and I have an asp page that allows you to retrieve information from the database. Everything works fine the first time, immediately after when you try the second time the page just comes up blank. No info from the database shows. If you wait a while it works again but once again another attempt gives a blank page. Is there some kind of setting in IIS I have to specify that would overcome this problem. I am using asp and i have specified only one recordset to open up. In fact I am using a Table Procedure. Not to sure if this is a problem but the OS is Windows 2000 running 256 or thereabout RAM. Service pack 4. If more information is needed I'll be glad to give it. Just in case, here's the Procedure:
Set oRSmt = Server.CreateObject("ADODB.Recordset")
oRSmt.CursorLocation = 3 'Used to keep count of how many records are going to be displayed
oRSmt.Open SourceIn, "DSN=" & dsnIn
Response.Write "<TABLE BORDER='1'><TR>"
For Each Field in oRSmt.Fields
Response.Write"<TH>" & Field.name & "</TH>"
Do While NOT oRSmt.EOF
For each objField in oRSmt.Fields
Response.Write "<TD>" & objField.value & " </TD>"
countn = oRSmt.RecordCount 'Assign the record count to variable countn
Response.Write "<p>Total Number of Entries are " & countn & "</p>"
sORce = Request.Form("report")
Hope I can get some help