title: Access 2010 and Oracle ODBC driver: The decimal field's precision is too small
body: <p>Create a table in oracle 11g:</p>
  
  <pre><code>create table test_table
  (
    id     varchar2(10 byte),
    price  number(5,2)
  )
  </code></pre>
  
  <p>Then insert a row:</p>
  
  <pre><code>insert into 
      test_table (id, price) 
  values
      ('id_1', 99.97)
  </code></pre>
  
  <p>Then add the table to MS Access 2010 as a linked table, using the Oracle ODBC driver (mine is: file "SQLORA32.DLL", version "11.02.00.01", date 2010-03-30). If Access asks for primary keys, then select "ID" field.</p>
  
  <p>Then open the table in Access (double clic on the table), to see the data. I get this error:</p>
  
  <pre><code>The decimal field's precision is too small to accept the numeric you attempt to add
  </code></pre>
  
  <p>Is it a bug? A bug in Access, or a bug in ODBC driver?</p>
  
  <p>How can I fix it?</p>