T
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
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