title: ADODB.Recordset error '800a0bcd' Classic ASP
body: <p>ADODB.Recordset error '800a0bcd'</p>
  
  <p>Either <code>BOF</code> or <code>EOF</code> is True, or the current record has been deleted. Requested operation requires a current record. </p>
  
  <blockquote>
    <p><strong>/login/reset_form.asp, line 8. Line 8 is rs.MoveFirst</strong></p>
  </blockquote>
  
  <pre class="lang-vbs prettyprint-override"><code>DIM mySQL, objRS, rs
  mySQL = "SELECT * FROM medacist_user WHERE username = '" &amp; strUsername &amp; "'"
  Set objRS = Server.CreateObject("ADODB.Connection")
  objRS.Open  "Provider=MSDASQL.1;Password=****;Persist Security Info=True;User ID=****;Data Source=****"
  Set rs = objRS.Execute(mySQL)
  
  rs.MoveFirst
  rs("Password") = Request.Form("Password")
  rs("DateLastUpdated") = Date()
  rs.Update
  
  objRS.Close
  Set objRS = Nothing
  
  Response.Write "&lt;div align='center'&gt;" &amp; strUsername &amp; ",&lt;br&gt;"
  Response.Write " Your password has been succesffully updated in our database.&lt;br&gt;&lt;br&gt;"
  
  objRS.Close
  Set objRS = Nothing
  objCONN.Close
  Set objCONN = Nothing
  </code></pre>