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.
Our Anniversary Sale is on during May! Save 50% on my Fundamentals. Dismiss