Get linked table connection's info through code

Z

zz12

Hello. I was wondering if anyone knew if there was a way to use a
successfully logged in link table connection info through vba code? I'm
trying to avoid having to hard code the connection string (Login id & PW) in
a vba procedure that runs an action query on sql server after a user
successfully provides their sql Login id and PW for a linked sql server
table that they have access to.

Thanks in advance.
 
Top