Replication Restrictions for Microsoft Access
-
SQL Server datetime, numeric, decimal, and many other datatypes are mapped to char. Numeric and decimal datatypes that are converted to char cause some precision loss.
-
Some character datatypes in SQL Server are not supported in Microsoft Access.