<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff size=2>No you
do not have to install RM on each machine. I have quite a bit of experience (and
good stories) with RM, so allow me....</FONT></SPAN></DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff size=2>In my
first experiments with replication, I needed to replicate a db among 4 branch
offices connected over the net with a vpn. In this phase, each office had a
server that was being hit by each local pc. The server at HQ had the
synchronizer installed, and it replicated among the office servers every 15
minutes. It worked flawlessly. Then I got to thinking that this same scenario
would work locally, and eliminate 90% of the net traffic that a classic FE/BE
would normally incur. So I set up a synchronizer on each branch server, and a
replica on each local pc. The branch server synchronized the local pcs with the
server BE every 5 minutes, and the HQ server synchronized the branch server
replicas.</FONT></SPAN></DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff size=2>All
replicas were set up as managed replicas, save one: the master replica, which
resided on my development box, alongside my own managed replica. When I modified
tables etc. and changed the FE to work against the master correctly, tested
etc., I was then ready to publish the changes. I manually synched my master
replica with my local replica. Five minutes later it synched with the branch
replica, propagating the changes both locally and company-wide. It worked
flawlessly for months, until eventually we migrated to SQL
2000.</FONT></SPAN></DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff size=2>As a
result of these experiments, I am now convinced that the classic FE/BE setup is
obsolete. The setup outlined above, even for a single office with say 20 users,
is dramatically faster than the classic layout.</FONT></SPAN></DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=912175812-13052003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>John
Skolits<BR><B>Sent:</B> May 13, 2003 8:45 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Replication
Manager or Briefcase<BR><BR></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=398403412-13052003><FONT face=Arial
color=#0000ff>Andrew,</FONT></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><FONT face=Arial color=#0000ff>Thanks for
getting back to me. I looked at Mike's site (haven't been there for a while-
Gee I wish he had a search tool).</FONT></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><FONT face=Arial color=#0000ff>I also
posted on the MS newsgroup and Mike responded. Here was his
comment:</FONT></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff>"Do not use the briefcase. It is less painful to hit
your hand with a hammer<BR>than to put yourself through that kind of
pain.<BR>MichKa [MS]"</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff>I like the way he is so direct. Anyway, I've been
doing a lot of reading from newsgroup postings and I'm confused about one
thing.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff>I'm getting the impression that I do have to install
the Rep Mngr app on each machine. </FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff>I'm thinking that I will want to periodically do
indirect Sync to my hub database but in order to do that, I will need the
synchronizer on each PC.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff>Here is a posting that talks about it. Is this person
wrong or do I misunderstand something.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff>Go to the following link and select the posting with
the topic: "<FONT face=Verdana color=#000000>What is the best way to do
this"</FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Arial color=#0000ff size=2><A
href="http://support.microsoft.com/newsgroups/default.aspx?NewsGroup=microsoft.public.access.replication&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups">http://support.microsoft.com/newsgroups/default.aspx?NewsGroup=microsoft.public.access.replication&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups</A></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Verdana size=1></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Verdana size=1></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Verdana>John </FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=398403412-13052003><SPAN class=606020412-13052003><FONT
face=Verdana size=1></FONT></SPAN></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Haslett,
Andrew<BR><B>Sent:</B> Monday, May 12, 2003 11:06 PM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE: [AccessD] Replication
Manager or Briefcase<BR><BR></FONT></DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2>Check out Michael Kaplans site:</FONT></SPAN></DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2><A
href="http://www.trigeminal.com">http://www.trigeminal.com</A></FONT></SPAN></DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2>He's the guru of Access Replication, and among other things, has made
his own 'replication manager' much more powerful than the one from MS.
The are a number of excellent articles on replication on his site
also.</FONT></SPAN></DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2>Additionally, you shouldn't need to install a replication
manager on each machine.</FONT></SPAN></DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=465330303-13052003><FONT face=Verdana color=#0000ff
size=2>Cheers,<BR>Andrew</FONT></SPAN></DIV>
<DIV><SPAN class=465330303-13052003></SPAN><FONT face=Tahoma><FONT
size=2><SPAN class=465330303-13052003><FONT face=Verdana
color=#0000ff></FONT></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=465330303-13052003> </SPAN>----Original
Message-----<BR><B>From:</B> John Skolits
[mailto:askolits@ot.com]<BR><B>Sent:</B> Tuesday, 13 May 2003 1:34
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Replication Manager or Briefcase<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=614424610-12052003><FONT size=2>
<P>I'm trying to decide which is the best method to handle
replication.</P>
<P>This will involve around 7 users. </P>
<P>I have 2 office locations: 1 in Philadelphia and 1 in Cleveland. The
are connected with an Asynchronous line. Therefore the data connection
will be slow. They will eventually switch to a regular T1 line, but not
for a few months.</P>
<P>I have looked at the Replication Manager which looks like a good fit
but I would have to install it on all the PC's and (I believe) have the
synchronizer running on the server where everyone would replicate to. I
would then do indirect synchronization.</P>
<P>Someone said they used the Briefcase to do the synchronizations. With
that method, I would not have to install Replication Manager on all the
PC's.</P>
<P>This is not mission critical information so the briefcase looks like a
better solution with much less programming overhead.</P>
<P>Anyone have any insights on this?</P>
<P>John</P></FONT></SPAN></DIV></BLOCKQUOTE><BR>
<P><B><FONT face=Arial size=2>IMPORTANT - PLEASE READ</FONT></B> <FONT
face=Arial size=2>******************** </FONT></P>
<P><FONT face=Arial size=2>This email and any files transmitted with it are
confidential and may </FONT></P>
<P><FONT face=Arial size=2>contain information protected by law from
disclosure. </FONT></P>
<P><FONT face=Arial size=2>If you have received this message in error,
please notify the sender </FONT></P>
<P><FONT face=Arial size=2>immediately and delete this email from your
system. </FONT></P>
<P><FONT face=Arial size=2>No warranty is given that this email or files, if
attached to this </FONT></P>
<P><FONT face=Arial size=2>email, are free from computer viruses or other
defects. They </FONT></P>
<P><FONT face=Arial size=2>are provided on the basis the user assumes all
responsibility for </FONT></P>
<P><FONT face=Arial size=2>loss, damage or consequence resulting directly or
indirectly from </FONT></P>
<P><FONT face=Arial size=2>their use, whether caused by the negligence of
the sender or not.</FONT></P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>