Problem with currency fields in Access to SQL Server linked tables

[andylecap]

I have upsized a database to SQL Server 2005. It works fine at the customer, but on my system when I view the data in Access any currency fields are blank, only zero values appear correctly. When I view the data on SQL Server the correct values are there. I am running Access XP and 2003, both give me the same prob1ems.

Anyone have any ideas please?

 

[lameid]

First thing that comes to mind is make sure sure you are using current ODBC drivers.