I have run across a problem on a few projects recently where in the same ASP script I use ADO to first perform some sort of update query, then open a recordset based on the same table. What I find is that by the time I access the recordset, the results of the update query are not reflected.<BR><BR>Example<BR><BR><BR>&#039Add A row to tblABC<BR>set DC = server.CreateObject("ADODB.connection")<BR>DC.Open DSN<BR>set c = Server.CreateObject("ADODB.Command")<BR>Set c.ActiveConnection = DC<BR>c.CommandText = "INSERT INTO tblABC (Field1) Select 1"<BR>c.Execute recs<BR><BR>&#039Retrieve all rows in tblABS<BR>set rs = server.CreateObject("ADODB.recordset")<BR>rs.Open SQL, DSN<BR>while not rs.eof<BR> response.write rs("field1")<BR> rs.movenext<BR>wend<BR><BR><BR>The result of this code never seems to include the new row I just added in the c.execute command. this problem also seems to happen on delete queries. I am out of ideas here. Has anyone overcome this?