Avatar of Melvyn Shepherd
Melvyn Shepherd
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Access 365 SQL 2019 EXPRESS Server, I keep getting the error ODBC-- Call Failed [Microsoft][SQL Server Native Client 11.0] Restricted datatype attribute violation (#0)

I have moved the Northwind Database to an SQL 2019 Express Server, I followed the instructions as per Steve Bishops Access 2013 Advanced Course. After I have selected the default employee and before it displays the 'Home' form, I get the above ODBC --Call Failed error. The form then displays but the inventory subform is empty. I also get the same error if I click on 'View-Inventory' on the right-hand side of the form.
Has anybody got any ideas why this is happening?

ps. I have gone through the SQL database and carefully set all primary and foreign keys, I assigned a default value of zero for all conversion generated Bit fields, I also set the SQL Identity Specification properties for all Access Autonumber fields.

The reason for doing all this is because, I plan to move my Customer Order Entry Access Application to SQL
DatabasesMicrosoft AccessMicrosoft SQL Server

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon