LinkBack URL
About LinkBacks
An excel worksheet was populated based on a Microsoft Excel query.
However, is there a way that the database password can be saved without allowing the user refreshing the query being able to see what the database password is.
An excel worksheet was populated based on a Microsoft Excel query.
However, is there a way that the database password can be saved without allowing the user refreshing the query being able to see what the database password is.
Find out where in the connection string the password is. For an ODBC database, it's in position 3 (starting the count as zero).
Put this in a open workbook module and then password protect the VBA Module - it's the best you can do.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
P.S. Turn off the background query option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks