Hi,<BR><BR>I have a necessity to use sql server and access together.<BR>And hence I&#039;m stuck at every point.<BR><BR>I&#039;m forming oDBC link from access to few sql server tables and trying to generate the reports.<BR>But the problem is: If I&#039;m running those queries manually from Access database, it prompts me for the "sa" username and password for connecting to the sql server to run the reports.<BR><BR>If I&#039;m doing this automatically from .NET code, how do I ignore the prompt while running the queries from Access to sql server or is there some way that I can hardcode the "sa" username and password while running the queries from Access to the linked sql server tables,<BR><BR>Thanks,.<BR><BR>