Sql/Access problem with Decimal fields

Hi,

I'm using an SQL database and i open some tables in
MsAccess through ODBC.
I have a problem with all the tables containing decimal
fields, i cant see the ',' character in it.
If the real decimal value is '1,23' Access shows me '123'.
Also i cant change any values of the records. I have the
same problem in Visual Basic 6.0.
If i open the tables with 'MSQRY32.EXE' i have no
problems, so it cant be an ODBC driver problem.

I've noticed the problem only occurs on some pc's. I've
done an ODBC trace of 1 pc with and 1 without problems:

PC WITH ERRORS:

Test 660-5b4 EXIT SQLGetData with return code
0 (SQL_SUCCESS)
   HSTMT 081B2760
   UWORD 2
   SWORD -8
<SQL_C_WCHAR>
   PTR 0x0013CE0C [
10] "20,55"
   SQLLEN 512
   SQLLEN * 0x0013D070 (10)

PC WITHOUT ERRORS:

Test 84-404 EXIT SQLGetData with return code
0 (SQL_SUCCESS)
   HSTMT 067E1718
   UWORD 2
   SWORD 1 <SQL_C_CHAR>
   PTR 0x0013E12C [
5] "20,55"
   SQLLEN 256
   SQLLEN * 0x0013E270 (5)

Thanks in advance for any suggestions,

David.<!-- ~MESSAGE_AFTER~ -->

Is your database SQL Server? Oracle? or some other database?

"David" <david.RemoveThis@staron.nl> wrote in message
news:0b7b01c3bb48$384548d0$a301280a@phx.gbl...
 > Hi,
 >
 > I'm using an SQL database and i open some tables in
 > MsAccess through ODBC.
 > I have a problem with all the tables containing decimal
 > fields, i cant see the ',' character in it.
 > If the real decimal value is '1,23' Access shows me '123'.
 > Also i cant change any values of the records. I have the
 > same problem in Visual Basic 6.0.
 > If i open the tables with 'MSQRY32.EXE' i have no
 > problems, so it cant be an ODBC driver problem.
 >
 > I've noticed the problem only occurs on some pc's. I've
 > done an ODBC trace of 1 pc with and 1 without problems:
 >
 > PC WITH ERRORS:
 >
 > Test 660-5b4 EXIT SQLGetData with return code
 > 0 (SQL_SUCCESS)
 > HSTMT 081B2760
 > UWORD 2
 > SWORD -8
 > <SQL_C_WCHAR>
 > PTR 0x0013CE0C [
 > 10] "20,55"
 > SQLLEN 512
 > SQLLEN * 0x0013D070 (10)
 >
 > PC WITHOUT ERRORS:
 >
 > Test 84-404 EXIT SQLGetData with return code
 > 0 (SQL_SUCCESS)
 > HSTMT 067E1718
 > UWORD 2
 > SWORD 1 <SQL_C_CHAR>
 > PTR 0x0013E12C [
 > 5] "20,55"
 > SQLLEN 256
 > SQLLEN * 0x0013E270 (5)
 >
 > Thanks in advance for any suggestions,
 >
 > David.
 ><!-- ~MESSAGE_AFTER~ -->