I'm using SQL Server 2008 and Access 2010 beta - but this problem occured with SQL Server 2005 and Access 2007 as well.
I have an Access adp connection to the SQL Server. I create a view that does a group by and sums a column which is type numeric(7,2). The result of the sum expression is inexplicably treated as text by Access. In SQL management studio, the column in the view is shown as numeric (38,2).
If I cast the source column as a float, the result is a float in Access. If I cast that float back to a numeric, Access treats it as text again.
What's going on? Is there an option in Access to fix this behaviour?