Trying to Link Azure server hosted locally to Access
I used the sql server native 11 ODBC driver, but I can't open any columns with a decimal column type. Is there a different ODBC driver I can use, or any settings, or do I need to set the columns to currenty or long or something Access will recognize? I have set the columns in the security area to Other-> Public, but that doesn't change the outcome.
ODBC Sql Server 17 doesn't load, I haven't tried ODBC Sql Server 13
Restricted Data type Attribute violation (#0)
Thanks in Advance