scaling of decimal error with linked ODBC table

  • Thread starter Thread starter Mike
  • Start date Start date
M

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.
 
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
 
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
 
Back
Top