Why is it when I link a view from a SQL Server backend to an Access front end
it converts the data type for one specific field to a Long Integer,
effectively truncating all the data that has anything in decimal form? I can
open all rows and look at the data in SQL server, and it is fine. But when I
look at it in Access, it's truncated. I looked in design view in Access, and
the data type is Long instead of double. It only does it for this one field.
All other fields are converted fine.