I use the following code to refresh three separate ODBC links pulling data from a proprietary SQLServer application
Each link requires that the user enters a long password. It would be much better if my users did not have to do this.
If I add the line Application.DisplayAlerts = False, the passwords are not needed, but the downloads don't happen either.
Is it possible for me to enter the password in the code?
Please Login or Register to view this content.
John
Hi,
I think that the password would usually be part of the connection string.
Don
Please remember to mark your thread 'Solved' when appropriate.
Duplicated thread ... http://www.excelforum.com/excel-prog...sqlserver.html
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks