Decimal-error when linking Oracle database tables via ODBC to Acce

[Guest]

I have this annoying problem when linking Oracle database tables via ODBC to
an Access database. The decimal dissapears: 115,12 becomes 11512.

On another PC next to me there is no problem?? Hope someone can help me with
this.

MartinC

 

[Guest]

Hi,
Your example shows a comma instead of the decimal point. I've seen a similar
problem when the regional settings were different between PCs. English
doesn't support the comma as a decimal; however, something like Argentina
will especially in currency formatting. Also you may need to check the NLS
settings in Oracle to make sure that you are all singing from the same sheet
of music when it comes to language, number, and currency settings.