Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logon Dialog prior to Open Database connection
Hi,
I'm using this code to open a database connection using ADODB inside VBA. What I would like to have is a dialog so that users must enter their username, password and DSN name. I don't like to have this information written in the code. I know that I can protect the code but still since there are several users using the same sheet. It will be easier for me to maintain it. Thanks Public db as new ADODB.Connection sub test() db.open "DSN name", "Username", "Password" ...... end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Connection | Excel Programming | |||
Database Connection | Excel Programming | |||
Database Connection from Excel | Excel Programming | |||
dialog box displayed when internet connection unavailable | Excel Programming | |||
DataBase Connection | Excel Programming |