scale in linked access table

N

Neil

I have a field in SQL that has a precision of 11 and a scale of 4 (9
decimals to the right and 4 to the left of the decimal places). When
viewed as a liked table in Access this is rounded to 2 decimal places.
When a user enters a number with 4 decimals in the table it appears to
them as only 2 but is correct if I query the SQL server directly.

Is there some setting in access that will allow me to see all 4 decimals
on linked table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top