I have successfully created several pass-through queries to an external database using ODBC and each of these queries successfully open individually. However, when I attempt to open more than one pass-through query, I get this message: ODBC--connection to '[XXXX]' failed.
I was using MS Access 2016 and have only just migrated to Access 365 which is when the error arose.