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.

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/ac...004941033.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

On Mon, 3 May 2010 13:35:01 -0700, Decembersonata
<(E-Mail Removed)> wrote:

>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.