Re-attaching backend db after drive change

[Needlejockey]

I have a big (reasonably big) Access 2003 db which I have split. On the E: drive this functions perfectly. Years ago I moved it to an other drive and found that to reach the back end again I had to change the drive letter in the link to the tables. Unfortunately I can't remember how I did it - all I remember is that somehow I brought up the link path and could then simply change the drive letter. I now find it necessary to put the db on an external drive for use with different computers. It will probably be easiest to put ".\" instead of a drive letter in the link, but after trying all menu options for db, tables and macros I still haven't found out how to access the link path. Can anyone help, please? John

[June7]

Right click on table to open the table link manager.

Or use code to set links. Recommend UNC pathing. Here is what I use:

Public Sub NormalizeTableLinks()
'Relink tables with UNC pathing
'Use the variables provided to do the manipulations desired
Dim td As TableDef
Dim db As DAO.Database
Dim strOld As String
Dim strNew As String
'replace the following strings as needed
strOld = "R:\Lab\Database\Data\LabData.accdb"
strNew = gstrBasePath & "Data\LabData.accdb"
Set db = CurrentDb
For Each td In db.TableDefs
    If InStr(td.Connect, strOld) > 0 Then
        Debug.Print td.Name
        Debug.Print "Old Link: " & td.Connect
        td.Connect = Replace(td.Connect, strOld, strNew)
        td.RefreshLink
        Debug.Print "New Link: " & td.Connect
    End If
Next td
db.TableDefs.Refresh
End Sub

gstrBasePath is a global constant declared in a general module header. The path string is in the form: \\servername\path\

[Needlejockey]

June7, thanks very much indeed. The table link manager did the trick, I wonder why I had not found that earlier. I'll have a good look at your code and add it to my snippets collection as well as to the current db. Thanks again. John