Is there a way to create passthrough queries without the password in the connection string, then allow the user to designate a password once for all the queries run so they don't have to keep entering the password for each query?

Thanks!


Michael

Hi Michael,

Welcome to the forum! I won't be conscious much longer, but they are some true Access geniuses that might be online in a few hours. Could you provide more details about your database?

I am assuming that you are linking to an external DB. What kind is it and how are you connecting? ODBC, etc.

All the best,

Mike

Mike
EchoVue.com

If the users are connecting to a SQL server, and you are using a DSN, then they will only have to log on to the server the first time they run a query or open a table etc.

This assumes that you have set up an account that uses SQL Server authentication, and not Windows NT authentication.

Does this help?

mmcdonal