"The Decimal field's precision is too small to accept the numeric you attempted to add"

[TONECHO]

I'm using Access 2000 linking FoxPro Tables via ODBC
When I link tables with numeric fields Access gives me an error:

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

I find this problem in "Knowledge Base"

I update my Windows XP to Jet 4.0 SP8 with Mdac 2.8 RMT and the last version
of FoxPro ODBC Driver and but the problem is the same.

Any help appreciated.

----------------------------------------------------------------------------
----

ACC2000: Scaling Errors When You Query Linked Tables

PSS ID Number: 270704

Article Last Modified on 10/16/2002


----------------------------------------------------------------------------
----

The information in this article applies to:

Microsoft Access 2000 Service Release 1 (SR-1)


----------------------------------------------------------------------------
----

This article was previously published under Q270704

SYMPTOMS

In Access 2000, when you run aggregate functions against decimal data types
that appear in tables linked from an ODBC data source, you may receive the
following error message:

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

RESOLUTION

To resolve this problem, install Jet 4.0 Service Pack 6 (SP6). For
additional information about how to obtain and install Jet 4.0 SP6, click
the article number below to view the article in the Microsoft Knowledge
Base:

239114 ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download
Center

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products
that are listed at the beginning of this article. This problem was fixed in
Jet 4.0 Service Pack 6 (SP6).



Additional query words: the decimal field s precision is too small to accept
numeric you attempted add

Keywords: kbbug kberrmsg kbQFE KB270704
Technology: kbAccess2000 kbAccess2000Search kbAccess2000SR1 kbAccessSearch

 

[charlesh]

I am having the exact same problem. Please let me know if
you receive an answer and I'll also let you know.

It does not seem as though anyone is able to answer this
question.

Charles