PC Review


Reply
Thread Tools Rate Thread

Accept username & password once; Use for multiple ODBC logins

 
 
wpiet
Guest
Posts: n/a
 
      13th Feb 2009
In a 2003 workbook with multiple sheets, each with a DB query, how can I have
a user enter username & password one time, then use these for each subsequent
ODBC login (to the same server) as I loop thru the sheets?
Now, each time the program hits 'Selection.QueryTable.Refresh,' the user has
to login again.
--
Will
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows Mail will not accept my username and password ladybug Windows Vista Mail 10 28th Jul 2010 08:14 AM
Input ID & password once for multiple ODBC logins wpiet Microsoft Excel Programming 0 13th Feb 2009 01:11 PM
RE: wont accept username and password-outgoing mail toto Windows Vista Mail 3 24th Jun 2008 11:50 PM
Re: wont accept username and password-outgoing mail Gary VanderMolen Windows Vista Mail 2 24th Jun 2008 09:37 PM
save username/password using ODBC =?Utf-8?B?QUVDSQ==?= Microsoft Access External Data 0 20th Mar 2006 05:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:05 PM.