Trouble with ODBC connection to SQL Server Table (1 Viewer)

[RogerCooper]

I recently got a new computer. When attempting to connect to a linked table in Access, I get the error ODBC--connection to <database> failed. It works fine on the old computer and the ODBC configuration is identical. When I test the ODBC connection from within ODBC Data Sources (32-bit) administrator, it is successful. Any ideas about what could be causing this issue.

 

[cheekybuddha]

Maybe your new computer is using 64bit Access?

 

[RogerCooper]

Both computers are using 64-bit Access. Maybe there is OS compatibility problem with 32-bit ODBC administrator? I am going to try to upgrade that.

 

[cheekybuddha]

If you are using 64bit Access then you need the 64bit ODBC connector