title: Update recordset without updating database
body: <p>I use an ADODB connection to connect to my Access DB in Excel VBA and get the records with a recordset. I want to update the recordset, but when i update the recordset i also update the table in the DB. Is it possible to update the recordset but not the db? Here is my code,</p>
  
  <pre><code>Dim con As New ADODB.Connection
  Dim rs As New ADODB.Recordset
  
  con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\jasons\Documents\UPD.accdb"
  rs.Open "SELECT ITEM, SL AS SL FROM Table2", con, adOpenDynamic, adLockPessimistic
  
  rs.MoveFirst
    Do
          rs.Update "SL", 250
          rs.MoveNext
      Loop Until rs.EOF
  
  con.Close
  Set con = Nothing
  </code></pre>