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?