I do not know if I follow your methodology for Importing. Just make sure you keep track of your original files (work on copies) and where your data gets imported to.
As for VBA code, you can go after the Connect property of a DAO.TableDef object. Here is a snippet where I iterate a list of known table names to update the Connect property with the correct file path to the backend. The file path is strPath.
Code:
While rs.EOF = False
If InStr(strPath, rs![FileName]) Then
Set T = d.TableDefs(rs![TableName])
' Debug.Print T.Name
T.Properties("Connect") = ";DATABASE=" & strPath
T.RefreshLink
End If 'instr
rs.MoveNext