MS Access linked table displays short text instead of Decimal data type
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.