Microsoft Access can’t always translate SQL Server data types correctly. Below is a list of the SQL Server data types (as of SQL Server 2012) and the type Access (as of Access 2013) will assign to it when connected.
