title: Log changes in a vb6 recordset
body: <p>I have and adodc object with a datagrid to have an editable table in vb6.
  I have to store any changes the users makes in the database.</p>
  
  <p>The first idea was to use <code>Sub grdDataGrid_Click()</code> to get the row which is being used, but for this, I need to know if any cells has been modified in that row and get the original and new values of it.
  Is there a way to check it?
  As I saw there are Will and Complete events for recordsets but I never used them before. Are they capable of getting the old and new values of a changed cell?
  I also thought about using an trigger (since it can get the old and new data) in oracle on the table I'm using, but in that case I can't get the user who is logged in and did the change.</p>
  
  <p>I'm up for any kind of ideas. It doesn't have to be in vb6 only, I can use stored procedures, functions, triggers if one thing alone is not enough.</p>