Bug #91532 Connector 5.3.10-win32 - MS Access cannot open Stored views 5.1.13 can.
Submitted: 2 Jul 2018 21:28 Modified: 3 Jul 2018 5:16
Reporter: Damon Endicott Email Updates:
Status: Analyzing Impact on me:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.3.10 OS:Windows (10)
Assigned to: Assigned Account CPU Architecture:x86

[2 Jul 2018 21:28] Damon Endicott
Noticed Excel could open a complex stored MySql View but MS Access 2010 or 2016 could not. Gave error: ODBC Failed. Developed a simple "Hello World" View and Access failed again. Created a new Connection using 5.1.13 and both the simple and complex views worked as expected.

How to repeat:
Create a view in mySQL: 
CREATE VIEW hello AS SELECT "Hello World" AS hello;

Create External Link in MS ACCESS using ODBC 32 bit connection through 5.3.10.
Double-click on the view in Access and get the error.

Create another connection using 5.1.13 and give it a unique name.
Create and External link in MS Access using the new connector to the "hello" view.
Double-click the hello "table" and it opens and displays.

Suggested fix:
Something changed between the two versions. Maybe inform the community which Connector setting are needed in the new version if that is all it is. I do not think this is an MS Access issue as it did not change.