File Path

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
 
J

John Nurick

It's in the Database field of MSysObjects - but the information is also
in the Connect property of the TableDef.
 

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

Access Print Files from Query Results 0
Excel tables linked to Access - Universal naming convention 1
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
Setting a relative path for a linked Excel File 1
Import Paths 12

Top