File Path

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a hidden table that stores the file path of linked files?
Thanks,
Gene
 
No, it is in the Connect property of the TableDefs Method of the CurrentbDB
object for each table:
CurrentDB.TableDefs("MyTableName").Connect
will return the path. For example:

?currentdb.TableDefs("cisattributetable").Connect
;DATABASE=\\rsltx1-bm01\busmgmt\dev ciscms\ciscmsdata.mdb
 
It's in the Database field of MSysObjects - but the information is also
in the Connect property of the TableDef.
 
Thankyou Klatuu, it was a useful suggestion for me (some years later ...)
Bye
 
You must log in or register to reply here.

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

What are the steps to fix damaged MDF files in SQL Server? 0
Access Print Files from Query Results 0
Excel tables linked to Access - Universal naming convention 1
How to Convert MBOX to PST Online? 3
Import File Information 0
import csv files without extension 2
Relative path to linked excel sheets 1
help please : importing many .txt files in a folder to one table 23

Back
Top