title: Preventing 'The data has been changed' error when using Me.Refresh with ODBC linked tables
body: <p>In my Access application's data entry form I'm using <code>Me.Refresh</code> to show the user the new value of a calculated field based on data they entered in a non-calculated field.  The purpose is to give them the deadline for doing a job next.</p>
  
  <p>This Access app is using linked SQL Server 2012 tables via ODBC.  The calculated field is in the underlying SQL Server table, not part of the Access Record Source query because I want to store the calculated value in the actual data, not just as an interface element.</p>
  
  <p>The calculation is very simple:</p>
  
  <pre><code>nextjob = jobdate + 79
  </code></pre>
  
  <p>So I have the field for <code>jobdate</code> set to run <code>Me.Refresh</code> after update.  All well and good.</p>
  
  <p>The problem is that if the user updates <code>jobdate</code>, triggers the refresh by moving to another field, then returns to the <code>jobdate</code> field and changes the date they entered Access throws a "The data has been changed by another user" error.</p>
  
  <p>I tested the method using native Access tables and the problem does not occur.  However the data needs to stay on the server, so moving to native tables is not a solution for me.</p>