Access - FoxPro: The Decimal field's precision is too small to accept the numeric

[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 las
version
of FoxPro ODBC Driver and 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 dat
types
that appear in tables linked from an ODBC data source, you may receiv
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 Microsof
Knowledge
Base:

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

STATUS

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



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

Keywords: kbbug kberrmsg kbQFE KB270704
Technology: kbAccess2000 kbAccess2000Search kbAccess2000SR
kbAccessSearc