Take a look at Dev Ashish's re-link code here:
http://www.mvps.org/access/tables/tbl0009.htm

In this code the path to the linked table comes from a Windows dialog but
you could modify it to come from a table that is internal to your FE.  
Assuming you know the proper paths for all your users, you could pre-load the
path to each user's BE database.

TomU

Another option, if you know the hardcoded path to the endusers tables, is to
mimic their setup on your own network.

Alternatively, you can do this:

Function RefreshLinks(strFileName As String) As Boolean
   ' Refresh links to the supplied database. Return True if successful.
   Dim dbs As Database, tdf As TableDef
   ' Loop through all tables in the database.
   Set dbs = CurrentDb
   For Each tdf In dbs.TableDefs
       If Len(tdf.Connect) > 0 Then    ' If the table has a connect string
           tdf.Connect = ";DATABASE=" & strFileName
           Err.Clear
           On Error Resume Next
           tdf.RefreshLink  ' Relink the table.
           If Err <> 0 Then Exit Function
       End If
   Next tdf
   RefreshLinks = True        ' Relinking complete.
End Function
This came from the Solutions.mdb database that ships with access ...
"FileName" is the path to the backend files. It probably could use some
polishing, but it'll do what you want.

------------------------------?---------------