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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
New computer, how do i move outlook 365 ENTIRELY? 0
Why linked sql database is read only 2
Linked table connection 0
ODBC Failure, error 18456 1
How To Bypass Login Prompt When Opening Linked Table 1
VBA to export large tables from Excel to SQL Server 1
change connection string to linked table with VBA 10

Top