Linked Table Attributes

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Thanks for taking the time to read my question.

I have a text file that I have linked to my database.

I am wondering if I can programmatically return the file
path and file name of the linked table (i.e. like the
info seen in Linked Table Manager)

I need this because I have code that links to a text file
before running a report. If the correct text file is
already linked, I don't want to relink it. If I can find
out the linked tables source, I can see if it is the same
as the one the user is requesting, and if it is, skip the
linking procedure.

Thanks again,

Brad
 
Parse the file name and path from the Connect property of the TableDef:
dbEngine(0)(0).TableDefs("MyTable").Connect
 
Back
Top