Automate MS Query ODBC User Name/Password

[Jeff]

I have an Excel file that has 10 queries for one sheet. I am using MS
Query to connect to an Access database for the query datasouce. When
a user opens the file, the data automatically refreshes, which I want.
But, I don't want them to have to put in the user name and password
10 times. How can I accomplish this? I have searched high and low
for this answer, and so far...nothing.
Thanks in advance for your help,
Jeff

 

[Jeff]

I tried this and Excel still prompts for a user/password. Also, I
have multiple users hitting this. Any suggestions??? Thanks!

 

[Mike A]

Change the properties for the ODBC driver.

Win98: Control Panel>ODBC Sources (32-bit)
Win2K: Control Panel>Administrative Tools>Data Sources (ODBC)
WinXP: Probably similar to Win2K, but I've never done this in XP...

Select the MS Access driver and click Configure. Click on Advanced
and enter the username/password as the default login information.

This would need to be done for each (client) machine.

Please respond so I know if this fixes it for you.


-Mike

I tried this and Excel still prompts for a user/password. Also, I
have multiple users hitting this. Any suggestions??? Thanks!

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers