global connection string in vba for sql server 1

[JacobTechy]

I have the connection string below in the open event of my form which works when I initially open the form, but when I click on a drop down box within that same form also pulling data from our sql server I get the sql server login using trusted connection window pop up. How can I make this connection string global. I have a ms access interface to sql server backend.

Dim Connect As String
Connect = "Driver={SQL Server};Server=servername;Database=dbasename;UID=;PWD=

 

[mrdenny]

You will want to post that in th Access programming forum.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com