I have a SQL Server table that contains datatypes of decimal. When I link the table in an Access database the datatype shows text instead of decimal. This is causing an issue when someone tries to enter a value with a comma. Has anyone had a similar problem. Do you know if there is a way to get around this. I know if I changed the SQL table to be numeric I would not have this issue but I can't do this now because the table contains over 10 million records and it is used by other programs.
Has anyone experienced this problem.
Has anyone experienced this problem.
