Linked tables with Navision SQL

xavigepe

Does anybody know why if we, using SQL ODBC link a Navision table in Access decimal data types are converted in the linked table as text types?.

Thanks,

bbrown

Access supports a maximum decimal precision of 28 digits. SQL allows 38 which is the setting used by Navision. Any decimal field with a precision higher than 28 then Access will treat it as text.

Create a view that formats the decimal fields with a precision that Access can support.