title: Write Conflict error in MS Access 2010 when i try to assign a record source
body: <p>I have SQL Server 2008 R2 linked tables in my MS Access 2010. </p>
  
  <p>I have many forms in this MS Access database. Few of my forms gets Write Conflict error when I try to assign it to a SQL statement as record source after I have updated very same record by SQL statement (or assign some values on form programmatically and refreshed the form in module) as I have general function being called every time I enter certain text on one of the field on form and it gets updated some of the forms fields value programmatically.</p>
  
  <p>I have a TIMESTAMP column in my table in SQL Server.</p>
  
  <p>So after updating the fields on the forms, when I try to assign a new record like
  <code>Me.Recordsouce = sqlstring</code> , I get a "write conflict" error.</p>
  
  <p>I tried to set on button click before I assign a recordsource  </p>
  
  <p>Refresh</p>
  
  <pre><code>Docmd.RunCommand AcCmdSaveRecord
  </code></pre>
  
  <p>But they all throw the same "Write Conflict" error and asking me to drop changes. </p>
  
  <p>Please help
  Many thanks,</p>