<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>So if
I understand this, you suggest foregoing the FE/BE design, place everything in
one DB and use replication? HMMM interesting.</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>But,
if I have 5 of 7 users on a local network, I would want their data refreshes to
be immediate on the data tables. The remote users won't care if they
refresh only periodically.</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>I
would think that in this scenario, I would prefer to have a FE/BE design on
the local network with the one shared BE being a replica. On the remotes, I
would also want FE/BE design but all their individual BEs be separate replicas.
</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>But,
now I'm mixing a shared BE and remote replica BEs. Is this a bad
idea?</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>In
addition, I like the idea of one replica on a local server
(sub-hub) managed by a synchronizer and then synchronized with the
main hub replica. </FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>But, I
thought each replica on the satellite PCs had to have a drop box. If that's so,
don't you have to install RepMnger on each PC have to have the drop
boxes?</FONT></SPAN><SPAN class=121305813-13052003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>Gee, a
lot to learn.</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2>John</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></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>Arthur
Fuller<BR><B>Sent:</B> Tuesday, May 13, 2003 9:06 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Replication
Manager or Briefcase<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>