Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to save SQLdatabase userid & password after link has been cre
Hello,
Not sure if this is the right group or not, but here goes my question: I've set up an SQL query from excel and everything works great. Everytime I need to update the data, it asks for userid & password. The userID is remembered. Now that I'm automating the update of the table with a macro, I'm in need of having the userID & password saved so that when the macro is ran (at night) the macro doesn't hang because the userID & password window pops up. Do you know of an option to save the database password so that it doesn't pop up that window? If I can't go into some settings to make it save the password, can I have this done in the VB macro? What does the code look like? thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script a userid and password (apache) | Excel Programming | |||
DSN UserId and Password Prompt | Excel Programming | |||
DSN UserId and Password Prompt | Excel Programming | |||
Web Query - UserID/Password Protected Textbox | Excel Programming | |||
FileSystemObject CopyFile with UserID/Password | Excel Programming |