I have several spreadsheets with ODBC calls to my DB which includes the DB password. Problem is when the DB password is changed, modifications to 100's a spreadsheets have to be made. Was wondering how to centeralize and streamline this process. Any and all ideas welcome! Thanx.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Password File
- Thread starter Deckster
- Start date
- Thread starter
- #3
Ugh. You may not like this suggestion (but it should be a one time ordeal):
option 1:
Have your DB check if pswd sent is new. if old pswd then send new pswd to spreadsheet.
Have code in spreadsheet write to the registry the new password.
option 2:
Save the new pswd in a text file (on the server).
Write code in spreadsheet to open & read txt file (from above), and use that for the password.
--MiggyD
option 1:
Have your DB check if pswd sent is new. if old pswd then send new pswd to spreadsheet.
Have code in spreadsheet write to the registry the new password.
option 2:
Save the new pswd in a text file (on the server).
Write code in spreadsheet to open & read txt file (from above), and use that for the password.
--MiggyD
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
