title: Numeric(15,6) - The decimal field's precision is too small
body: <p>I add a decimal field in ms access 2003. Its data type is <strong>Numeric(15,6)</strong>. </p>
  
  <p>In access, I define it like below</p>
  
  <blockquote>
    <p>Data Type: 'Numeric'.</p>
    
    <p>Field Size : Decimal</p>
    
    <p>Precision : 15</p>
    
    <p>Scale : 6</p>
    
    <p>Decimal Places : 6</p>
  </blockquote>
  
  <p>From Window application, I try to modify its value to </p>
  
  <blockquote>
    <p>'123456.22223'</p>
  </blockquote>
  
  <p>. I got this error - </p>
  
  <blockquote>
    <p>The decimal field's precision is too small to accept the numeric you attempted to add.</p>
  </blockquote>
  
  <p>But in ms access, using sql command, I can update this value. Why?</p>
  
  <p>My vb.net code is below</p>
  
  <pre><code>mClass.ExchRate = IIf(txtExchRate.Text = "", 0.0, CDec(txtExchRate.Text))
  </code></pre>
  
  <p>Here, data type of ExchRate field of mClass is also decimal. And then pass this value to sql update command.</p>