Access 2007/sql2008 ODBC issue

[Decembersonata]

My unit just upgraded to sql2008 and I am linking to these tables via an ODBC
connection through Access 2007. The issue I am having is with two types of
field formats. The first are fields that in sql2008 are in Currency format,
but when I connect to them via ODBC they come across as Number format fields.
The second example are fields that are Date/Time format and come across as
Text format. Is there something I need to switch in my Data Sources that is
causing this format changing? What else might it be. Thanks.

 

[Mary Chipman [MSFT]]

At the bottom of this help topic you'll find the information you need
about how Access interprets SQL Server data types:
http://office.microsoft.com/en-us/access/HA102004941033.aspx

Money should be interpreted as Currency, and datetime should be coming
through as Date/Time. To troubleshoot, I'd stick a Profiler trace on
the app and see what is happening under the covers. Here's a link for
getting started:
http://msdn.microsoft.com/en-us/library/ms181091.aspx.

HTH,

Mary