VBA in Excel doing SQL

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.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!