[AccessD] Access 2002 insists on SQL Server trusted connection

Phil Jewett pjewett at bayplace.com
Tue Nov 11 20:34:31 CST 2003


When I run my Access 2000 frontend on a Windows XP/Access 2002 box, the
SQL Server 2000 login fails, insisting on the 'trusted connection'
network login instead of the SQL Server authentication in the ODBC
connection string.  This was presumably fixed in MDAC 2.6 SP2 - but
maybe only for Access 2000.  It's still there for Access 2002!  See
http://support.microsoft.com/default.aspx?scid=kb;en-us;279526 for MS's
info.  Any help on this?

Thanks,

Phil Jewett



More information about the AccessD mailing list