Trouble with ODBC connection to SQL Server Table

RogerCooper

Registered User.
Local time
Today, 15:45
Joined
Jul 30, 2014
Messages
614
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.
 
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.
 
If you are using 64bit Access then you need the 64bit ODBC connector
 

Users who are viewing this thread

Back
Top Bottom