Hey experts! I have a client who has users with both 32 and 64 bit OS's. They have 32 bit Office installed universally.
For non-terminal server (TS) users everything works fine... for the 64-bit Terminal Server users however, the ODBC connection is not working.
When logging into TS as administrator we open Windows\SysWow64\odbcad32.exe and see the connection and can test it successfully.
From within the Access application however, when I try to link to the ODBC table it only brings up the non 64-bit odbc driver.