Trusted Connection to SQL Server

[Steve101]

I am linking to a couple of SQL Server tables from my Access application. Security is not an issue, and I wish to be able to establish the connection when the database is opened, without being prompted to provide the SQL Server login and password (in my case, the default "sa" and blank password. )

The connection is defined via a Data Source Name using the ODBC Administrator.

How do I set up the connection so that I am not prompted to provide the Login information? I'm running on a Windows 2000 platform with strong user authentication at logon.

Any help would be appreciated.

Thanks,
Steve