Access 2010 linked table - solve the "decimal field's precision" error
I had a similar problem, the fix was a linked table refresh.  Access was not aware that the precision had changed in my Oracle table and kept giving me the 'precision too small' error.