Method to Update table from one db to another

[Middlemarch]

If I have 2 databases with identical table structures, can I update a record from one to the other without iterating all the fields?
I think possibly an Update query using INTO but I'm not 100% sure.


And if yes, but there's only one field to update should I specify it, or do all fields regardless?

[ArviLaanemets]

Contain both tables always same data, and the new data are always entered into table in 1st DB?

When this is the case, then simply link the table in 1st DB into second one?

[moke123]

If you don't want to maintain a link to the other table and want to link and unlink on demand you could use code like: (obviously use your own variables/arguments)

        DoCmd.TransferDatabase acLink, "Microsoft Access", strFile, acTable, strTargetTable, strTargetTable

Public Sub UnlinkTable(strTableName As String)


    CurrentDb.TableDefs.Delete (strTableName)
    
End Sub

[Middlemarch]

Thanks for the suggestions, Am trying them out.