Path of back-end

[George]

Hi all,

In Acess XP, one can use Application.CurrentProject.Path
to determine the path of the front-end. Is there a similar
way to determine the path of the back-end?

TIA.

 

[Ken Snell]

I use a query that returns the name of the backend using a linked table
name:

SELECT MSysObjects.Database
FROM MSysObjects
WHERE (((MSysObjects.ForeignName) Like "NameOfALinkedTable"));

 

[Marshall Barton]

In Acess XP, one can use Application.CurrentProject.Path
to determine the path of the front-end. Is there a similar
way to determine the path of the back-end?

Which back end? Every linked table in the front end could
be in a different back end.

You can extract the path to a linked table's mdb file from
the linked table's Connect property:

Dim dbFE As Database
Dim tdf As TableDef
Dim strBEpath As String

Set dbFE = CurrentDb()
Set tdf = dbFE.TableDefs("nameoflinkedtable")
strBEpath = Mid(tdf.Connect, 11)