title: MS Access Form Bound to ADO Disconnected Recordset
body: <p>I seem to be clueless on this subject. I can attach an ADO recordset to a form, but I am not sure how to handle updates. I don't want to only UpdateBatch, I want to be able to detect what was changed for logging purposes. Can anyone point me in the right direction?</p>
  
  <p>The supplied SQL contains one Key field which is an Autonumber named "ID". </p>
  
  <pre><code>Private Sub Form_Load()
      Dim rst as Object
      Set rst = CreateObject("ADODB.Recordset")
      rst.CursorLocation = adUseClient
      '...edit out connection
      rst.Open sql, mConnection, adOpenStatic, adLockBatchOptimistic
      set rst.ActiveConnection = Nothing
      Set Me.Recordset =  rst
  End Sub 
  
  ''Edit records on the form and now click save
  Private Sub cmdSave_Click()
      Dim rst As Object
      Set rst = Me.Recordset
      Set rst.ActiveConnection = GetConnection
      rst.UpdateBatch
      'How do I detect deleted, added, or modified records for logging? 
  End Sub
  </code></pre>