SQL Server Money Data Type

[cerduga]

Hi All. I`ve searched forum without success (though someone had the same question two years ago but with no replies)

In Access I am linking a SQL server table and everything works fine except that money type fields do not appear in the Access linked table. The field is simply left blank whilst other fields are drawn correctly. ¿How can I get around this working only in Access? (because I don´t have access to the SQL server tables)

Any help is greatly appreciated

 

[pbaldy]

Where are you seeing blanks? I link Access to SQL Server all the time, and often use the money type. I've never had a problem with it working or displaying correctly. What versions of each do you have, and how are you linking?

 

[cerduga]

SQL Server 2000 SP4
MS Access 2003, Windows Vista

I`m seeing the blanks on the linked table (in access) but only on the money data type.
And I`m linking through the File|Get External Data menu

 

[tehNellie]

have a similar setup here (access 2002 and XP) and linking the table replicates the problem this end.

Created table on SQL Server with 1 column, datatype money.
Populated table with three values.

Linked table to access using pre-existing dsn.

queries using criteria against the column return the correct rows, the values just aren't visible in Access.

 

[cerduga]

have a similar setup here (access 2002 and XP) and linking the table replicates the problem this end.

Created table on SQL Server with 1 column, datatype money.
Populated table with three values.

Linked table to access using pre-existing dsn.

queries using criteria against the column return the correct rows, the values just aren't visible in Access.

Yes, I do get the column but the values aren`t visible

 

[tehNellie]

Well I'm stumped for the time being. I've tried a few things in the DSN config and at an Access level and I still can't get the values to display.

 

[tehNellie]

OK, I think I've got it.

our SQL server is set to English US and our workstations are set English UK. If I change my workstation to English US the values display correctly. There's got to be a more elegant way of handling this though, the search goes on.

[edit] Changing the language settings on the sql server account used to connect to the DB doesn't seem to help any.

 

[cerduga]

OK, I think I've got it.

our SQL server is set to English US and our workstations are set English UK. If I change my workstation to English US the values display correctly. There's got to be a more elegant way of handling this though, the search goes on.

Did that but didn`t work, I linked the tables on a different PC (Access 97, Windows XP) and it worked perfectly, I don`t know what else to do on my computer

 

[SQL_Hell]

You could just use a decimal or numeric data type with a precision of 2, that would be the same as the money data type wouldn't it?

 

[cerduga]

Well I had some issues on my pc and we decided to install a different OS (Windows XP), then installed Access 2003. After that I opened the linked tables through Access and no problem, but it kept telling me to install Microsoft Jet 4.0 Service Pack 8, and the same problem aroused.
So now I know the problem lies in Microsoft Jet 4.0 Service Pack

 

[cerduga]

You could just use a decimal or numeric data type with a precision of 2, that would be the same as the money data type wouldn't it?

I don´t have write permission on the sql server; so all the changes must be done on my PC.

 

[cerduga]

Solved!!! I kept on digging for answer and found a guy with the same problem: "In case anyone else may hit the same problem, Ingres Corp identified the cause of the problem as in version 3.50 of the Ingres ODBC driver, and have issued patch 11389 which resolves the issue.
The patch can be obtained by request from Ingres or via their ftp site.
Best Regards,
Phil "

So you have to download it at:

http://download.openlinksw.com/download/product_matrix.vsp?p=f_os&fm=5&fam=1&df=6

Thanks for the help

 

[rope1111]

have a similar setup here (access 2002 and XP) and linking the table replicates the problem this end.

Created table on SQL Server with 1 column, datatype money.
Populated table with three values.

Linked table to access using pre-existing dsn.

queries using criteria against the column return the correct rows, the values just aren't visible in Access.

Thank u for this post, it helped me, I was also facing such kinda problem Now its solvedd