I have an Access 2000 DB that has an ODBC connection to a SQL 6.5
Server. The server is runing in Mixed Mode (SQL Authentication and NT
Authentication). I can open the ODBC connections if I use SQL
authentication (my SQL username and password). I cannot use a trusted
connection to open the Access DB. I can use a trusted connection to
open Enterprise Manager.

I have the following DLL versions on my PC:
ntwdblib.dll 7.00.623
dbnmpntw.dll 8.0.1.85

The ODBC connection I have set up is using NT securty and when I test
it works.

The error I get in Access is:

Connection failed:
SQL State '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User:
Reason: Not associated with a trusted SQL Server connection.

Any ideas on what I am doing wrong?

thanks
Brian