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?