title: SQL Server - MS Access cannot handle decimal(19,4) type
body: <p>I've searched everywhere for some advice on this, however have come up with nothing. We have a database running on SQL server.</p>
  
  <p>We want to convert a field (used for currency) from numeric(18,2) to numeric / decimal(19,4).</p>
  
  <p>I have tried to convert it multiple times, updated the table link and have the following error:</p>
  
  <ol>
  <li>After the field type conversion and updating the links - <strong>the records all work fine</strong>.</li>
  <li>If I then update a value within the numeric column to have 4 decimal places (e.g. I change 12.34 to 12.3456)</li>
  <li>The record successfully updates in the database</li>
  <li>After this <strong>I cannot re-update that particular record at all - even other fields</strong></li>
  </ol>
  
  <p>I cannot think of any reason why this would be the case and am hoping some SQL server expert could shed some light on it for me?</p>
  
  <p>Thanks in advance!!!!
  Karl</p>