I know how to determine the file location of the current Access
database in VBA. But I'm trying to figure out how to determine the
file location of my back-end. Anybody know how I can call up the path
& name of the .mdb with my tables in it -- from a module in my front-
end?

Public Function ShowTables()
Dim I As Integer
With CurrentDb
For I = 0 To .TableDefs.COUNT - 1
If Len(Trim(.TableDefs(I).Connect)) 0 Then
Debug.Print .TableDefs(I).Connect
Debug.Print .TableDefs(I).SourceTableName
End If
Next
End With
End Function
evenlater wrote:

>I know how to determine the file location of the current Accessdatabase in VBA. But I'm trying to figure out how to determine thefile location of my back-end. Anybody know how I can call up the path& name of the .mdb with my tables in it -- from a module in my front-end?

>I know how to determine the file location of the current Access
database in VBA. But I'm trying to figure out how to determine the
file location of my back-end. Anybody know how I can call up the path
& name of the .mdb with my tables in it -- from a module in my front-
end?