VBA in Excel doing SQL

stokak

I have an odbc connection set up where my VBA code retrieves info from a SQL database. It works OK, but I have to enter the password every time. The UserID is embedded. How can I embed the password ? Sometimes a window opens and I have time to enter the password, and sometimes that window appears and disappears very quickly and i can't enter the password. This may be some other access tothe SQL database shutting down my connection?....so if i can embed the password it will work.
Thanks