CODEWITHSUNDEEP
sql-serverms-accessms-access-2010
Sathish
Sathish

Reputation: 25

decimal(18,10) values in SQL Server appear rounded in Access linked table

I have an Access database with a linked table from SQL Server.

The SQL Server table has the table structure and the values as below

Name        |Total  |Esc    |Variance (Data Type decimal (18,10))
================================================
Name        |29     |2      |0.0689655170

but if i open the Access linked table it is showing the Variance value rounded to two decimal places

Name        |Total  |Esc    |Variance
================================================
Name        |29     |2      |0.07

How can I make the Access table look the same as the SQL Server table?

Upvotes: 0

Views: 1700

Answers (1)

Parax
Parax

Reputation: 11

I had this same problem with a Decimal(18,10) on SQL2005 with Access 2010 Front End. Linked table rounds/truncates data.

I have found that this occurs with the default sqlsrv32 ODBC driver updating to the sql Native client driver and creating a new ODBC connection to use the sqlncli driver seems to fix the error.

Upvotes: 1

Related Questions