>Is there a way to display the current back end db that the front end is linked to? I have a front end that I use to link to one of several back ends depending on which client I am dealing with. I am going to have to distribute the front end to some end users who might be confused as to which back end they are currently using. I would like to put a label on the interface that displays the current back end information. Any Ideas?
>
>Thanks to J. Crescencio Flores for help with yesterday's CurrentDB.Name answer.
>
>TIA for any help
Here is an idea how to retrieve connection path for linked tables:
Dim loTd As TableDef
Dim dbase As DAO.Database
Dim strConnect As String
Set dbase = CurrentDb
dbase.TableDefs.Refresh
For Each loTd In dbase.TableDefs
strConnect = dbase.TableDefs(loTd.Name).Connect
If strConnect <> vbNullString Then
msgbox strConnect
End If
Next
set loTd=Nothing
Set dbase=Nothing
HTH
Igor Gelin
Database Developer