MySQL Bugs: #91532: Connector 5.3.10-win32 - MS Access cannot open Stored views 5.1.13 can.

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:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.3.10	OS:	Windows (10)
Assigned to:	Assigned Account	CPU Architecture:	x86

Description:
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.