2

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?

1 Answer 1

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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