ODBC Decimal problem
411285Dec 16 2003 — edited Jan 5 2004Since we use a new application (in Oracle8) to which I a get connected with MS Access 2000, trough an Oracle 8 ODBC driver, I do have a problem with numeric fields of the type decimal. I get an error message: "The decimal field's precision is too small to accept the numeric you attempted to add". As you may know you cannot influence the format of a linked table. When we used a driver Microsoft ODBC for Oracle, we did not have this problem, but that driver is not used for the new application.
How can I solve this problem?