MS Access displaying NULL values in currency column after upsizing to SQL 2008

Software: MS Access 2003 / MS SQL 2008

After upsizing a database, a currency column in a particular table was completely empty via the Access application. However, when viewing the table in SQL 2008,  the values are present in “money” format.

Suggested workarounds didn’t really fit for us (eg changing the workstations to English US and upgrading ODBC drivers). In the end we altered the tables properties from “Currency” to “Number” with double integer / currency / 2 decimal points

We then upsized the table again and all is working correctly. Success!