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