File Path

K

Klatuu

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

How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Straight Line Path with Arrow at both ends 0
AddPicturesToShapes 0
Error outlook.com 0xc0000005 trying to open custom controls 0
Working outlook via vba code with xlsx - error 0
Create a dynamic master file 1
Excel file linked to external source 0
Doughnut Chart linked with the slicer in the pivot table 0

Top