Re: Replication process

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Jeff" <Jeffrmarks@xxxxxxx> wrote in
news:1167344094.281110.307220@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

I have a small Access database with 1 parent, and 10 child
records. I know that I want a configuration with 2-way
synchronization. There will be updates done at the main office and
by people on the road who will synch up daily.

I was able to create a master and replica database through
instructions in Access, but I can't find any instructions on how
to do the synching process. Could someone help me with this?

You want to do it programmatically? Then you have to answer this
question:

-- Will the users by synchronizing across a LAN (10Mbps or higher
bandwidth, wired not wireless connection)?

If so, then it's basically one line of code. Here's how to do it
with DAO (the best method):

Dim dbLocal As DAO.Database

Set dbLocal = DBEngine.OpenDatase("C:\Path\LocalReplica.mdb")
' DIRECT SYNCH
dbLocal.Synchronize "\\Server\Share\RemoteReplica.mdb"

dbLocal.Close
Set dbLocal = Nothing

You'll need to set a reference to DAO.

However, if you want your users to synch over the Internet, then you
need to use indirect replication, and that's a whole other kettle of
fish. To understand all of this you'll need to go to:

http://www.dfenton.com/DFA/Replication/

and read the 3rd topic listed there, "Resources for learning about
Jet Replication." The links you need are all there. After you've
read that, you'll want to read this post of mine explaining how to
set up indirect replication without Replication Manager:

http://groups.google.com/group/microsoft.public.access.replication/ms
g/3b7167c1462b2d2f

and you may want to refer to this article that covers the same
ground:

http://www.vsj.co.uk/articles/display.asp?id=560

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

Relevant Pages

  • Do this plan sound feasible?
    ... and Banda Aceh - it's for an NGO working with the Tsunami relief). ... connection is too slow to run the DB over. ... I am facing a problem which I think is best solved by replication. ... could I do direct synchronization? ...
    (microsoft.public.access.replication)
  • Re: Replica Synchronisation and so on.
    ... down the replication road unless it is absolutely required. ... would require some synchronization, though not a whole lot since they ... Utter Access VIP ... into a Design Master. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is replication the right answer for this scenario
    ... The reference to Excel data has only to do with the fact that they are ... The replication comes into play because the principals of the business want ... >> and synchronization will only take place while connected to their LAN. ... > The best way to minimize conflicts is to keep them from happening in the ...
    (microsoft.public.access.replication)
  • Re: Replication Manager
    ... folder called 'Synchronization', ... As I reviewed the Replication White Paper, ... * Graphical user interface and tools for system ... without needing ReplMan, ...
    (microsoft.public.access.replication)
  • RE: Is replication the right answer for this scenario
    ... > and synchronization will only take place while connected to their LAN. ... Access Replication could be a good candidate for this. ... The best way to minimize conflicts is to keep them from happening in the ... Microsoft Online Partner Support ...
    (microsoft.public.access.replication)