1

I have linked tables in MS Access databases (various versions, 2007-2019) which are connected to SQL server 2017 via Sql server 2017 drivers (eg, msodbcsql_17.2.0.1_x64). Fields that are of data type Decimal(38,20) in SQL server are showing as type Short Text in the linked tables.

According to the Documentation, the data types are directly comparable.

Why might this be coming through as a different data type?

0

I have discovered that even though the data types are directly comparable, the data precision is not. Access can handle a max precision of 28, hence why the conversion into short text.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.