Microsoft Access Error "The Decimal Field's Precision is Too Small to Accept The Numeric You Attempted to Add." (Doc ID 1313850.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Generic Windows
Microsoft Access

Symptoms

You are using an Oracle 11g Client and Oracle ODBC Driver to link a table from Microsoft Access to Oracle.  You receive the following Microsoft Access error:

The decimal field's precision is too small to accept the numeric you attempted to add.

The Oracle ODBC Driver is using  the default settings in the Oracle ODBC Driver DSN Configuration screen.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms