"Forced Replication"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Although some of the users must synchronize from a distance, I would like to
develop a macro that would automatically synchronize the replicas located
within the same building/server. I have some senior executives that wish to
view the data but I am not sure the 'lessons' on how to synch each time they
view the data will go over well. It would be nice to have a macro, possibliy
using a scheduler program, that would synch each of the replicas during off
hours. Are you aware of a macro, program or other method that I might
accomplish this? I know that I can individually synch, but I would like to
automate the process.
 
Thank you for the direction. I cannot find the automate replication issue on
the listing... is this the same as "indirect synchronization?" Sorry, I
would still consider myself a newbe on this although I have developed a
number of databases. I will check my various Access books for this
particular issue but if you know of a "best" book, that would help.

Again, thanks for the help!
 
There isn't a step-by-step process in the FAQ. Synchronizing
programmatically is illustrated in section 8: "How can I synchronize in a
single direction?" It can be as simple as:
Call SynchronizeDBs("C:\MyRepl.mdb", "L:\OtherRepl.mdb")



Sub SynchronizeDBs(strDBName As String, strSyncTargetDB As String, _

intSync As Integer)



Dim dbs As DAO.Database



Set dbs = DBEngine(0).OpenDatabase(strDBName)



dbs.Synchronize strSyncTargetDB, dbRepImpExpChanges

End Sub



But that's deceiving, because if you have a conflict, you have to manage
that yourself. There is code provided in other sections to do this.



As for trade press books, Allison Balter's books usually have a section on
replication including how to use DAO to automate it. Check and see if you
can find a current version book by her.




--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top