Automate MS Query ODBC User Name/Password

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
Right-click anywhere in the cells where your query data is returned,
and select Data Range Properties from the context menu. Check 'Save
Password' and 'Save Query Definition'.

If you have 10 different queries, you will have to do this for each of
them.

-Mike



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
Click to expand...

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
 
I tried this and Excel still prompts for a user/password. Also, I
have multiple users hitting this. Any suggestions??? Thanks!
 
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!
Click to expand...
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
 
Back
Top