Group:  Microsoft Access ยป microsoft.public.access.replication
Thread: Programmatically synchronizing replicas...

Geek News

Programmatically synchronizing replicas...
Atomic Storm <jswinstrom[ at ]microsoft.com> 5/30/2007 3:35:31 PM
I have read a few posts about synchronization and I was wondering
something... most everyone talks about Direct, Indirect and Internet
sync's, but no one (even the online/offline help) has any examples of
programmatically forcing a replica sync with the DM. Does anyone know where
I can find good, solid code examples, explainations or both regarding
programmatic synchronization?

Thanks in advance.
Re: Programmatically synchronizing replicas...
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 5/30/2007 5:50:37 PM
Atomic Storm <jswinstrom[ at ]microsoft.com> wrote in
news:Xns994056F13D375jgwinstrommicrosoft[ at ]207.46.248.16:

[Quoted Text]
> I have read a few posts about synchronization and I was wondering
> something... most everyone talks about Direct, Indirect and
> Internet sync's, but no one (even the online/offline help) has any
> examples of programmatically forcing a replica sync with the DM.
> Does anyone know where I can find good, solid code examples,
> explainations or both regarding programmatic synchronization?

Well, first off, why do you want to force a synch with the Design
Master? The DM should not be participating in regular production
editing and should not be synched as often as the replicas into
which data is being added/edited.

How to do a programmatic synch will depend on which type of synch
you are using. With DAO, it's very simple, and code is found
everywhere that shows how to do it:

Dim dbLocal As DAO.Database

Set dbLocal = DBEngine.OpenDatabase([local replica])
dbLocal.Synchronize [remote replica]

dbLocal.Close
Set dbLocal = Nothing

For indirect, it's substantially more complicated, because there are
a lot more dependencies.

But for direct (i.e., on a LAN), it's really *very* simple.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net