Invoking SQL Server login

[hirenJ]

Hi all, I have an access query that is querying a SQL server database. Every time the query is run, the SQL Server login box is invoked. Is there a way of invoking this SQL server login in code, without running the query?


(i am working in Access 2K)

ThANKS

Hiren

) make peace with yourself before you kick the computer...

 

[cmmrfrds]

If you are using an access project (adp) the connection to the SQL Server database is made when you enter the application. Any queries developed from that point on can use the active connection. An access project makes it easy to work with an SQL Server database and you shouldn't run into what you are experiencing.

If you want to create a query in VBA code you can supply the connection string which can include the login and password, but if you use the ActiveConnection (from the adp) then it already has the login and password.