Connecting to SQL Server

[glove]

I have an Access database that contains some links to tables in an SQL database. On all the computers on my network except one I can open the database with no problem, but on one of the computers it requires me to log on the SQL server. What is causing this?

 

[foxdev]

Sounds like you are using integrated (NT) security as the authentication method, and that one computer is not part of the same NT domain. Just a WAG.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[TomSark]

Ensure that the NT account that is being used has access to the SQL Server. Also, if you are using pass-through queries, make sure that the ODBC DSN is can connect and that the account in the DSN can connect as stated above...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com