Hi Nigel,

I'm not sure what you mean by "That works in one instance".  That code
actually does loop through a subset of the tables collection (the function
fGetLinkedTables() weeds out the ODBC connection tables). Regardless, here
is the basic code that demonstrates how you would loop through a recordset:

You can still use the code from fRefreshLinks as a guide for what you need
to do inside the loop. Basically you need the tablename and the path to the
linked database.

Open the recordset (once)
Test for records (EOF and BOF are both true when empty),
Loop through stopping when the EOF condition is reached.
   Inside the loop we do something with each record,
   Move to the next record
Close the recordset
Destroy the object variables.

Public Sub WalkRecordset()
Dim rst As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb()
'tblMyTables is the name of your table
Set rst = db.OpenRecordset("Select * from tblMyTables")
With rst
   If Not (.EOF And .BOF) Then
       Do Until .EOF
           ' Here is the place to put the action you want to take on
           ' each record - use the code in  fRefreshLinks as a guide
           Debug.Print "TableName:" & .Fields("TableName")
           .MoveNext
       Loop
   End If
   .Close
End With
Set rst = Nothing
Set db = Nothing
End Sub