DoCmd.TransferDatabase TransferType:=acLink, _
   DatabaseType:="Microsoft Access", _
   DatabaseName:="\\UNCname\YourBackendDatabase.accdb", _
   ObjectType:=acTable, _
   Source:="YourSourceTableName", _
   Destination:="YourDestinationTableName"