Access Linked Table Data Type

[AccessHelp123]

Hi,

I created a linked table in Ms Access from a view in sql Server. The problem is that all the fields in the linked table show up as text even though the table in sql server has data type decimal(38,17) for some columns. When I run a query in Ms Access against the linked table, values seem to be truncated. For example if in Sql server the value is 0.94000000000000006 it shows up as .94000000000000006
in Ms Access Query results. Can anyone help with this issue? Thanks.

 

[randy700]

SQL Value = 0.94000000000000006
Query value = .94000000000000006

There's a difference?


Randy