I am running Access 2003. I am linking to a table from an SQL 2000 Server that includes a decimal field (precision 8, scale 4). When I view the field in the linked table in Access, the decimal amount has been round up and only displays 2 decimal places.

What could cause this conversion?