>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