Okay, granted I've been doing Oracle for the past 6 years, with 0 Access experience and some Sqlserver experience.

I'm trying to connect to sqlserver from access. Everytime it tells me I'm not a trusted connection when I run a pre-existing query. A little box comes up. I un-check the trusted connection box and enter a valid user that I can log in with. Still Access tells me that sqlserver says I'm not a trusted connection. Why does it ignore login/password for SQLServer? Is this an Access problem?

Is there some sort of a global flag in Access or SqlServer that says all connections must be from trusted connections.




(956) 423-6100 x113
1-800-395-9353
FAX (956) 423-4519

---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
MS Sql Server LazyDBA home page