Access / SQL Server currency datatypes

When linking a SQL server 2000 table to Access 2003 using the standard MS
ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
are blank in Access.
If I use a DataDirect ODBC driver the money fields are displayed correctly.
Any Idea if there is a MS ODBC driver that displays money correctly?
You might want to ask this question in one of the Access newsgroups
since it isn't an ODBC or a SQL Server issue. Someone there may have
the answer you seek.
--Mary
On Tue, 14 Mar 2006 06:02:26 -0600, "Simon
Lampert"<ureader@.byteaccess.com> wrote:

>When linking a SQL server 2000 table to Access 2003 using the standard MS
>ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
>are blank in Access.
>If I use a DataDirect ODBC driver the money fields are displayed correctly.
>Any Idea if there is a MS ODBC driver that displays money correctly?