Linked Table Attributes

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
 
A

Allen Browne

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

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

Linked Table Attributes (Extra help needed) 5
Change drive letter in linked table manager 5
Unlink and Relink 2
Linked Table Attributes 2
Access: Relink table to text file using VB 0
How to connect to a BE database? 0
VB to see if file is present and linked table question. 5
Creating combobox in Linked Table through VBA 4

Top