G
Guest
Is there a hidden table that stores the file path of linked files?
Thanks,
Gene
Thanks,
Gene
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
Already answered in another group.
J
John Nurick
It's in the Database field of MSysObjects - but the information is also
in the Connect property of the TableDef.
in the Connect property of the TableDef.
L
lucainbici
Thankyou Klatuu, it was a useful suggestion for me (some years later ...)
Bye
Bye