Access data truncation error with decimal data (error 3759)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After just upgrading MS Access 97 to MS Access 2003 my queries that use
linked ODBC tables stopped working and now I receive the above error message.
I know that this has something to do with decimal places, but since the query
uses solid database I can not change the data format.

There must be a fix to this problem, please someon help!
 
-eppu- said:
After just upgrading MS Access 97 to MS Access 2003 my queries that use
linked ODBC tables stopped working and now I receive the above error message.
I know that this has something to do with decimal places, but since the query
uses solid database I can not change the data format.

There must be a fix to this problem, please someon help!
Click to expand...
Try converting the data type. Access does not like the DECIMAL data
type. I ran into a similar situation with a MYSQL DB I could not
change. At the very bottom most query, replace any references to
[anydecimalfield] to CDbl([anydecimalfield]). At that point, it is no
longer a decimal field type, and the math should work OK.
 
I did what you said, and now I got another error message: "Error 3163: Field
is too small for desired input". Any help with this one, I would appreciate.

Phil said:
-eppu- said:
After just upgrading MS Access 97 to MS Access 2003 my queries that use
linked ODBC tables stopped working and now I receive the above error message.
I know that this has something to do with decimal places, but since the query
uses solid database I can not change the data format.

There must be a fix to this problem, please someon help!
Click to expand...
Try converting the data type. Access does not like the DECIMAL data
type. I ran into a similar situation with a MYSQL DB I could not
change. At the very bottom most query, replace any references to
[anydecimalfield] to CDbl([anydecimalfield]). At that point, it is no
longer a decimal field type, and the math should work OK.
Click to expand...
 
I think I know solved the problem, I added Nz-function to all decimal fields
and now the queries seem to run ok.

-eppu- said:
I did what you said, and now I got another error message: "Error 3163: Field
is too small for desired input". Any help with this one, I would appreciate.

Phil said:
-eppu- said:
After just upgrading MS Access 97 to MS Access 2003 my queries that use
linked ODBC tables stopped working and now I receive the above error message.
I know that this has something to do with decimal places, but since the query
uses solid database I can not change the data format.

There must be a fix to this problem, please someon help!
Click to expand...
Try converting the data type. Access does not like the DECIMAL data
type. I ran into a similar situation with a MYSQL DB I could not
change. At the very bottom most query, replace any references to
[anydecimalfield] to CDbl([anydecimalfield]). At that point, it is no
longer a decimal field type, and the math should work OK.
Click to expand...
Click to expand...
 
Back
Top