Trying to Link Azure server hosted locally to Access (1 Viewer)

sportsguy

Finance wiz, Access hack
Local time
Today, 09:21
Joined
Dec 28, 2004
Messages
358
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

ERROR
ODBC--Call failed
Restricted Data type Attribute violation (#0)

Thanks in Advance
 

sportsguy

Finance wiz, Access hack
Local time
Today, 09:21
Joined
Dec 28, 2004
Messages
358
Using the CAST function solves the issue. . .
 

Users who are viewing this thread

Top Bottom