Other users unable to open ODBC linked table in Access (1 Viewer)

[AccessNut]

Here's the set up:

I am the dbo of a SQL Server 2008 database, and we have an Access front end. I have 2 users that both have db_datareader rights to the SQL server db. They have the exact rights in SQL server 2008. User A linked a table from the SQL db in the Access front end, which I can open via ODBC. However, User B cannot open it. The error msg says "ODBC -- Connection to XXXX failed". User B then links a table, and I cannot open it, nor could User A. I then link a table, User A can open it, but not User B.

Is there some security setting in Access that can be causing this problem?

 

[Fear Naught]

This seems to me to be a conflicting ODBC Connection. Ensure that all users have the same DSNs to the Sql Database on their PCs.

I have had similar issues with Access databases that link to SQL Server.

HTH