Is there a hidden table that stores the file path of linked files?
Thanks,
Gene
Klatuu - 24 Aug 2005 19:01 GMT
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
> Is there a hidden table that stores the file path of linked files?
> Thanks,
> Gene
Klatuu - 24 Aug 2005 19:03 GMT
Already answered in another group.
> Is there a hidden table that stores the file path of linked files?
> Thanks,
> Gene
John Nurick - 24 Aug 2005 19:12 GMT
It's in the Database field of MSysObjects - but the information is also
in the Connect property of the TableDef.
>Is there a hidden table that stores the file path of linked files?
>Thanks,
>Gene
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.