Query Error - Specified DSN Contains an Architecture Mismatch

 

Summary

Error appears in Query when trying to use a Microsoft Access 64 Data Source.

Additional Comments

Showcase Query is a 32 bit application. Data source must be created using the 32 bit ODBC administrator. On Windows 64 bit operating system the 32 bit ODBC administrator is located here. C:\Windows\SYSWOW64\ODBC32.exe