CODEWITHSUNDEEP
sql-serversql-server-2008ms-accesstype-conversionsqldatatypes
Tamas
Tamas

Reputation: 39

SQL Server Numeric data type turns into Short_Text in MS Access

We have SQL Server 2008 running on a server. I linked the MS Access 2013 to tables of one of the SQL Server's database via ODBC (SQL Server Native Client 10). Everything seemed OK till now, when I realized that one data type has changed while it was coming from the SQL Server to Access.

The data type in SQL Server is Numeric(38,8) yet in MS Access it became Short_text. Any ideas why is this happened and what should I do to tackle this problem?

Thanks

Upvotes: 2

Views: 1838

Answers (1)

Muhammad Gouda
Muhammad Gouda

Reputation: 869

The reason is that you selected a number for precision which is 38 that is larger than the maximum acceptable precision by MS Access 2013 which is 28

So, It failed to map it to Number data type in access, that's why it was converted to short_text

However, I see this is a bug in ODBC, as it was supposed to provide a warning or show something in the log. But when I tried it myself, I found the log is empty

Upvotes: 1

Related Questions