Using 64-bit ODBC with 64-bit Excel - Unable to access view tables

SUGGESTED

We have a customer that uses view tables created to optimize queries run in MS Query.  These queries run in 32-bit ODBC and 32-bit Excel, but do not run with the 64-bit versions of the same.  All other tables aside from view tables are able to be accessed and used; however, this is not feasible for this customer as the queries take hours to run when using standard tables and less than an hour with the view tables based on the standard tables.

Any information on if this is fixable, and if it is fixable, the steps to take to do so would be greatly appreciated.

Included below are the error message and one of the queries.