scaling of decimal error with linked ODBC table

[Mike]

using access 2000 to a linked ODBC table. if i try to
agreegate a numeric field i get the error 'scaling of
decimal value resulted in data truncation'.
i have applied all necessary pathces including Jet 4.0
Service Pack 6 (SP6). the issue has not been fixed.
any advice greatly appreciated.

 

[Michel Walsh]

Hi,


That seems due to the fact you tried to store a number out of limit of
its precision, as sated by the table design. It is a "data" error, not a
error from the application. As example, trying to store 123456.78901 in a
place where you previously said, in the table design, here, for illustration
only, that you only accept 5 digits in all, and not more than two digits in
the fractional part. Clearly, the number just don't fit in the old specs,
so, the data "warning-error". No application patch will do anything, since
it is an error with the data (in respect with the spec made at the table
design).


Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Hi,


That seems due to the fact you tried to store a number out of limit of
its precision, as sated by the table design. It is a "data" error, not a
error from the application. As example, trying to store 123456.78901 in a
place where you previously said, in the table design, here, for illustration
only, that you only accept 5 digits in all, and not more than two digits in
the fractional part. Clearly, the number just don't fit in the old specs,
so, the data "warning-error". No application patch will do anything, since
it is an error with the data (in respect with the spec made at the table
design).


Hoping it may help,
Vanderghast, Access MVP