<html><div style='background-color:'><DIV>
<P>Arthur,</P>
<P>How does workgroup security play into all this? Can replicas have different workgroups? With users/groups having different rights at different replicas?Or is it all controlled at the DesignMaster, one for all and all for one?<BR>_d<BR></P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Arthur Fuller" <ARTFUL@ROGERS.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>Date: Tue, 13 May 2003 09:06:01 -0400
<DIV></DIV>>
<DIV></DIV>>No you do not have to install RM on each machine. I have quite a bit of
<DIV></DIV>>experience (and good stories) with RM, so allow me....
<DIV></DIV>>
<DIV></DIV>>In my first experiments with replication, I needed to replicate a db among 4
<DIV></DIV>>branch offices connected over the net with a vpn. In this phase, each office
<DIV></DIV>>had a server that was being hit by each local pc. The server at HQ had the
<DIV></DIV>>synchronizer installed, and it replicated among the office servers every 15
<DIV></DIV>>minutes. It worked flawlessly. Then I got to thinking that this same
<DIV></DIV>>scenario would work locally, and eliminate 90% of the net traffic that a
<DIV></DIV>>classic FE/BE would normally incur. So I set up a synchronizer on each
<DIV></DIV>>branch server, and a replica on each local pc. The branch server
<DIV></DIV>>synchronized the local pcs with the server BE every 5 minutes, and the HQ
<DIV></DIV>>server synchronized the branch server replicas.
<DIV></DIV>>
<DIV></DIV>>All replicas were set up as managed replicas, save one: the master replica,
<DIV></DIV>>which resided on my development box, alongside my own managed replica. When
<DIV></DIV>>I modified tables etc. and changed the FE to work against the master
<DIV></DIV>>correctly, tested etc., I was then ready to publish the changes. I manually
<DIV></DIV>>synched my master replica with my local replica. Five minutes later it
<DIV></DIV>>synched with the branch replica, propagating the changes both locally and
<DIV></DIV>>company-wide. It worked flawlessly for months, until eventually we migrated
<DIV></DIV>>to SQL 2000.
<DIV></DIV>>
<DIV></DIV>>As a result of these experiments, I am now convinced that the classic FE/BE
<DIV></DIV>>setup is obsolete. The setup outlined above, even for a single office with
<DIV></DIV>>say 20 users, is dramatically faster than the classic layout.
<DIV></DIV>>
<DIV></DIV>>Arthur
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com] On Behalf Of John Skolits
<DIV></DIV>>Sent: May 13, 2003 8:45 AM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Andrew,
<DIV></DIV>>
<DIV></DIV>>Thanks for getting back to me. I looked at Mike's site (haven't been there
<DIV></DIV>>for a while- Gee I wish he had a search tool).
<DIV></DIV>>
<DIV></DIV>>I also posted on the MS newsgroup and Mike responded. Here was his comment:
<DIV></DIV>>
<DIV></DIV>>"Do not use the briefcase. It is less painful to hit your hand with a hammer
<DIV></DIV>>than to put yourself through that kind of pain.
<DIV></DIV>>MichKa [MS]"
<DIV></DIV>>
<DIV></DIV>>I like the way he is so direct. Anyway, I've been doing a lot of reading
<DIV></DIV>>from newsgroup postings and I'm confused about one thing.
<DIV></DIV>>I'm getting the impression that I do have to install the Rep Mngr app on
<DIV></DIV>>each machine.
<DIV></DIV>>I'm thinking that I will want to periodically do indirect Sync to my hub
<DIV></DIV>>database but in order to do that, I will need the synchronizer on each PC.
<DIV></DIV>>
<DIV></DIV>>Here is a posting that talks about it. Is this person wrong or do I
<DIV></DIV>>misunderstand something.
<DIV></DIV>>Go to the following link and select the posting with the topic: "What is the
<DIV></DIV>>best way to do this"
<DIV></DIV>>
<DIV></DIV>>http://support.microsoft.com/newsgroups/default.aspx?NewsGroup=microsoft.pub
<DIV></DIV>>lic.access.replication
<DIV></DIV>><HTTP: DIV < default.aspx?NewsGroup="microsoft.pu" newsgroups support.microsoft.com>>blic.access.replication&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups>
<DIV></DIV>>&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>John
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Haslett, Andrew
<DIV></DIV>>Sent: Monday, May 12, 2003 11:06 PM
<DIV></DIV>>To: 'accessd@databaseadvisors.com'
<DIV></DIV>>Subject: RE: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Check out Michael Kaplans site:
<DIV></DIV>>http://www.trigeminal.com
<DIV></DIV>>
<DIV></DIV>>He's the guru of Access Replication, and among other things, has made his
<DIV></DIV>>own 'replication manager' much more powerful than the one from MS. The are
<DIV></DIV>>a number of excellent articles on replication on his site also.
<DIV></DIV>>
<DIV></DIV>>Additionally, you shouldn't need to install a replication manager on each
<DIV></DIV>>machine.
<DIV></DIV>>
<DIV></DIV>>Cheers,
<DIV></DIV>>Andrew
<DIV></DIV>>
<DIV></DIV>> ----Original Message-----
<DIV></DIV>>From: John Skolits [mailto:askolits@ot.com]
<DIV></DIV>>Sent: Tuesday, 13 May 2003 1:34 AM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: [AccessD] Replication Manager or Briefcase
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>I'm trying to decide which is the best method to handle replication.
<DIV></DIV>>
<DIV></DIV>>This will involve around 7 users.
<DIV></DIV>>
<DIV></DIV>>I have 2 office locations: 1 in Philadelphia and 1 in Cleveland. The are
<DIV></DIV>>connected with an Asynchronous line. Therefore the data connection will be
<DIV></DIV>>slow. They will eventually switch to a regular T1 line, but not for a few
<DIV></DIV>>months.
<DIV></DIV>>
<DIV></DIV>>I have looked at the Replication Manager which looks like a good fit but I
<DIV></DIV>>would have to install it on all the PC's and (I believe) have the
<DIV></DIV>>synchronizer running on the server where everyone would replicate to. I
<DIV></DIV>>would then do indirect synchronization.
<DIV></DIV>>
<DIV></DIV>>Someone said they used the Briefcase to do the synchronizations. With that
<DIV></DIV>>method, I would not have to install Replication Manager on all the PC's.
<DIV></DIV>>
<DIV></DIV>>This is not mission critical information so the briefcase looks like a
<DIV></DIV>>better solution with much less programming overhead.
<DIV></DIV>>
<DIV></DIV>>Anyone have any insights on this?
<DIV></DIV>>
<DIV></DIV>>John
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>IMPORTANT - PLEASE READ ********************
<DIV></DIV>>
<DIV></DIV>>This email and any files transmitted with it are confidential and may
<DIV></DIV>>
<DIV></DIV>>contain information protected by law from disclosure.
<DIV></DIV>>
<DIV></DIV>>If you have received this message in error, please notify the sender
<DIV></DIV>>
<DIV></DIV>>immediately and delete this email from your system.
<DIV></DIV>>
<DIV></DIV>>No warranty is given that this email or files, if attached to this
<DIV></DIV>>
<DIV></DIV>>email, are free from computer viruses or other defects. They
<DIV></DIV>>
<DIV></DIV>>are provided on the basis the user assumes all responsibility for
<DIV></DIV>>
<DIV></DIV>>loss, damage or consequence resulting directly or indirectly from
<DIV></DIV>>
<DIV></DIV>>their use, whether caused by the negligence of the sender or not.
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Help STOP SPAM with <a href="http://g.msn.com/8HMUENUS/2731??PS=">the new MSN 8 </a> and get 2 months FREE*</html>