D David W. Fenton Nov 6, 2007 #2 Is there some coding for a macro to synchronize a database? Click to expand... You mean to synchronize two Jet replicas? I don't use macros, so I can't tell you how to do that, nor if it's even possible. The code for synchronizing two replicas on the same LAN is very simple: Dim dbLocal As DAO.Database Set dbLocal = DBEngine.OpenDatase("C:\Path\LocalReplica.mdb") dbLocal.Synchronize "\\Server\Share\RemoteReplica.mdb" dbLocal.Close Set dbLocal = Nothing You can put this code behind a command button on a form, or save it in a module as a function and call it with RunCode in a macro.
Is there some coding for a macro to synchronize a database? Click to expand... You mean to synchronize two Jet replicas? I don't use macros, so I can't tell you how to do that, nor if it's even possible. The code for synchronizing two replicas on the same LAN is very simple: Dim dbLocal As DAO.Database Set dbLocal = DBEngine.OpenDatase("C:\Path\LocalReplica.mdb") dbLocal.Synchronize "\\Server\Share\RemoteReplica.mdb" dbLocal.Close Set dbLocal = Nothing You can put this code behind a command button on a form, or save it in a module as a function and call it with RunCode in a macro.