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

« Macro is not able to identify the value. | Accept & Use ODBC Login »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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