ODBC password in Excel

M

Michele

I have the same issue as another user (Eddie 9/224/04). However, we have a
data source that is being used for all parties and they cannot have their own
logins for security reasons. We have created a read only account that they
can use, but I need Excel to remember the password rather than them calling
me to fill it in every time they run a query. Can anyone tell me where I can
enter this once so that they can run the queries on their own?

Any help would be greatly appreciated.

Thanks -
 
Top