ACC2000: "Error 3701: 'Invalid Scale for Decimal Datatype'" Error Message When You Try to Link an Informix Table to an Access Database

When you try to link an Informix table to a Microsoft Access database, you may receive the following error message:

This issue may occur if the following two conditions are true:

• The Informix table contains fields with the Decimal (16,0) datatype.
  
  -and-
• You use an outdated version of the Informix Open Database Connectivity (ODBC) driver.

To resolve this issue, upgrade the Informix ODBC driver. To do this, follow these steps:

1. Download and install the most current Informix ODBC driver. For more information, visit the following Informix Web site:
   
   http://www.informix.com
   
   You can also download an evaluation copy of a similar driver from DataDirect Technologies. For more information, visit the following DataDirect Technologies Web site:
   
   http://www.datadirect.com/index.ssp
2. Download and install the most current version of Microsoft Data Access Components (MDAC). To do this, visit the following Microsoft Universal Data Access Web site:
   
   http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e
3. Create a System DSN to use the new ODBC driver.
4. Link the Informix database table to your database.

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.