Linked tables with Navision SQL

xavigepe
xavigepe Member Posts: 185
edited 2008-07-08 in NAV/Navision Classic Client
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,

Comments

  • bbrown
    bbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.

Categories