troubleshooting Question

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)

Avatar of Melvyn Shepherd
Melvyn ShepherdFlag for United Kingdom of Great Britain and Northern Ireland asked on
DatabasesMicrosoft AccessMicrosoft SQL Server
15 Comments1 Solution36 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros