Can anyone tell me how to prevent rounding up in a table. I have tried to change the table properties from Long Integer to Decimal however I cannot as "This property cannot be modified in linked tables". Any help would be greatly appreciated. Thankx
Did you ever get an answer to this? I am having the same issue. A SQL table linked into Access. In SQL it is numeric with 2 scale and in Access it rounds up no matter the format I put on it. IT is defaulting to a long integer data type.