Im not sure what is it you are looking for. But if your problem is how to manually link back tables in a database using a function. then I guess use :
'delete the current table currently on the system
DoCmd.DeleteObject acTable, TargetTable
'create a linked or imported table to the current database
DoCmd.TransferDatabase acLink, "ODBC Database", StrCon, acTable, _
SourceTable, TargetTable
acLink or acImport depending on the type of table whether a linked or imported table.
StrCon is the ODBC connection String
acTable is the type of object you want to import.
|