title: suppress write conflict message in Access VBA
body: <p>My problem. </p>
  
  <p>I have written a stored procedure to calculate a number of fields that are being presented through a form on an Ms Access front end (to a MSSQL2000 db).</p>
  
  <p>as soon as I call <strong>Me.Form.Requery</strong> to get the changed values. I can the irritating message that I have caused a write conflict.</p>
  
  <blockquote>
    <p>This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
    Copying the changed to the clipboard will let you look at the values the other user entered,
    and then paste your changes back in if you decide to make changes.</p>
  </blockquote>
  
  <p>I know that its me that has changed the data so I want to suppress the message or prevent the message from occurring.</p>