Microsoft KB Archive/319485

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

Article ID: 319485

Article Last Modified on 8/17/2007

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q319485



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



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

Error 3701 &quot;Invalid scale for decimal datatype.&quot;



CAUSE
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.



RESOLUTION
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-technologies.com/odbc/connectodbc/opxconnectodbc.asp
 * 1) 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
 * 1) Create a System DSN to use the new ODBC driver.
 * 2) Link the Informix database table to your database.



MORE INFORMATION
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.

Additional query words: prb

Keywords: kberrmsg kbprb KB319485

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.