Previous Thread

7/14/2006 9:48:45 AM    Create A Replica Partner List
Greetings, 
 
I have a split db that the back end db is replicated. I have a form 
 
that the users open when they need to synch with the replica hub. 
 
Occassionally, the users will be on the road and need to synch with 
 
each other. What table and fields would I need to query to build a list 
 
of replica partners similar to the list that appears when you select 
 
Syncronize Now from the Tools | Replication menu?



7/14/2006 8:06:23 PM    Re: Create A Replica Partner List
"yerbmeld" <embreydl@yahoo.com> wrote in 
 
news:1152895725.686646.225560@m73g2000cwd.googlegroups.com: 
 
MSysReplicas has the replicas in it. 
 
-- 
 
David W. Fenton                  http://www.dfenton.com/ 
 
usenet at dfenton dot com    http://www.dfenton.com/DFA/

7/15/2006 10:32:23 AM    Re: Create A Replica Partner List
Okay, MSysReplicas is the table. Now how about answering the other 
 
portion of my question concerning the fields I need to be concerned 
 
with. I can review the MSysReplicas table and see that not all the 
 
replicas in the table appear in the list provided when I click 
 
Synchronize now. 
 
Darrell 
 
David W. Fenton wrote:

7/15/2006 8:17:31 PM    Re: Create A Replica Partner List
"yerbmeld" <embreydl@yahoo.com> wrote in 
 
news:1152984743.820676.158120@s13g2000cwa.googlegroups.com: 
 
Don't be so demanding -- you have no right to an answer to the 
 
question. 
 
Check the REMOVED column. I don't know exactly what the numbers 
 
mean, but I think any replica with a null or0 value will show up in 
 
the list. 
 
Also, there's the question of accessibility. You don't want to 
 
display replicas that are inaccessible to the replica you're 
 
synching from. I don't know exactly how you determine this for 
 
yourself, but for a laptop user, I would only allow synchronization 
 
with the hub on the server in the main office. I can't see any 
 
utility in suggesting a synch with another laptop user, so would 
 
filter all of those out of the list. 
 
-- 
 
David W. Fenton                  http://www.dfenton.com/ 
 
usenet at dfenton dot com    http://www.dfenton.com/DFA/