I'm connecting from an Access 2003 .mdb via ODBC to a MS SQL Server database under Windows XP SP2. In the connected tables there are some fields of the SQL Server datatype DECIMAL.
In the data received by Access those numbers are 100times bigger than on the server - it seems, that the decimal point is forgotten somewhere in between.
Im working in a german system environment (server and client), where ',' is used as the decimal separator instead of '.', but if I use the same ODBC connection with Excel, I can see the numbers properly.
Any hints?
greez,
Hansjörg Grafen
In the data received by Access those numbers are 100times bigger than on the server - it seems, that the decimal point is forgotten somewhere in between.
Im working in a german system environment (server and client), where ',' is used as the decimal separator instead of '.', but if I use the same ODBC connection with Excel, I can see the numbers properly.
Any hints?
greez,
Hansjörg Grafen