Questions about Tables and Recordset and VBA

[Chatbox]

In my access project, I have a few Linked Tables (to a SQL server on the network).

Question 1: How do I get the connection string (via VBA coding) that each of the linked tables is using?

Question 2: (If Q1 is not possible) How do I create an ADODB.Recordset from a linked table when I don't have a connection string?

Thanks.

 

[Chatbox]

Anyone?

How come there's no reply? Is it because it's too easy/obvious and no one can bother...or no one know the answer?