Hello
I am using MS Query to return results in my excel file from an ODBC source which only a specific group of people have access to. Whenever the query is refreshed the user credentials are requested.
I had our IT dept. create a default log on for the system the query is pulling from but can someone please tell me how I can program the default credentials to automatically enter so that the user doesnt ever had to put them in?
Thank you!
-Ryan
I am using MS Query to return results in my excel file from an ODBC source which only a specific group of people have access to. Whenever the query is refreshed the user credentials are requested.
I had our IT dept. create a default log on for the system the query is pulling from but can someone please tell me how I can program the default credentials to automatically enter so that the user doesnt ever had to put them in?
Thank you!
-Ryan
