Synchronize to ALL Replicas

bbulla

I'd rather be golfing
Local time
Today, 07:44
Joined
Feb 11, 2005
Messages
101
Hi,

Is it possible to synchronize to ALL replicas using a command button in one shot from the Design Master?? I've read various posts, and it doesn't sound like anybody has found a solution for this. Found solutions for doing it one at a time, but was wondering if anybody has found a way to synchronize to all replicas without any user interaction other than hitting a button.

Thanks,
 
replicas? replica db's, forms, queries, tables? please clarify! and if its db's then are the seperate db's on a networked location? If so then why not have a front-end / back-end system?
 
Replica DBs that are stored on tablet PCs and taken into the field. Once they return, I want them to replicate to the Master. That is not a problem.

But....if I make a change to the Master I would like to be able to update all of the replicas in one shot assuming the tablets are all connected to the network at the same time.
 
You should not be using replication for the front ends. It will eventually corrupt the project irretrievably. See the best practices section of my Jet Replication Wiki:

http://www.dfenton.com/DFA/Replication/index.php?title=Best_Practices

For distributing front-end changes, you can send it out via email, but you'll need to have a method of relinking the front-end tables to the local data replica.
 
On the issue of synchronizing all the replicas, you can get the list of all the replicas from the MSysReplicas table and loop through a recordset and attempt a synch.

But you don't want to do that except when all the replicas are connected to the network. That is, it's not often going to work very successfully.

I believe that synchs should be triggered by the end user from each individual replica, not from any central server.
 

Users who are viewing this thread

Back
Top Bottom