ODBC--call failed [MySQL][ODBC 5.3(w) Driver]pmysqld-5.7.15-log] Sort Aborted

[Kurt Vangsness]

I have 3 tables in a MySQL Data Schema on which I am trying to perform a summary query in MS Access via ODBC. The query connects the tables via Left Joins, i.e., Table 1=>Table 2=>Table 3. The joined fields have indexes.

Table 1 contains about 1.9 million records
Table 2 contains about 15 thousand records
Table 3 contains about 100 records

The MySQL Schema is connected via System DSN using the 32-bit MySQL ODBC 5.3 Unicode Driver.

When I run the Query, I receive the following error message in MS Access:

++++++++++++++++++
ODBC--call failed.
[MySQL][ODBC 5.3(w) Driver]pmysqld-5.7.15-log]Sort Aborted: Query execution was interrupted, maximum statement execution time exceeded (#1028)
++++++++++++++++++

I haven't been able to find anything via multiple searches on the MySQL site or in other developer forums that illuminates the issue and why it is occurring.

Is this a ODBC or MySQL settings issue or setup issue or is it a Performance issue or other?