David Emerson
davide at dalyn.co.nz
Thu Mar 20 18:08:00 CST 2003
I have been involved with A97 replication for a number of years. While definitely not an expert, I have tried a number of methods. In all cases I distributed a runtime version of Access. I found that internet synchronization was a disaster because of lack of security on the server (it needed anonymous user access which meant that anyone could get in - and did!). Now I use dial up connections and indirect synchronization. I distribute replication manager as part of the installation and once it is configured on the users machines they are (mostly) able to follow the simple synchronization process using it. I am not sure about XP but would be pretty certain that it would be distributable as well. David Emerson Dalyn Software Ltd New Zealand At 20/03/2003, you wrote: >No, I haven't. When I've used replication, I didn't try to do it on a >schedule because I had no control over the users' >schedules. Procedurally, our users were instructed to sync their replica >at the beginning of each session to get the latest updates and at the end >of a session to upload their own changes. You could set up code to sync >the database when they opened it, but there is at least a slight delay >involved with that. > >Charlotte Foust >-----Original Message----- >From: Doug Murphy [mailto:doug at murphyscreativity.com] >Sent: Thursday, March 20, 2003 1:36 PM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Access XP Developer and replication manager > >Charlotte, > > > >Thank you. I guess my ignorance is going to show here but that is how I >learn, sometimes. My objective, I think, is to have the replication >manager on the users system so I can set up the replicas on the various >computers and set up the synchronization schedule. From what I understand >if I use the Access menu I can make the replicas and put them on the >various computers but I can not get automatic synchronization, or indirect >synchronization. It seems like a real waste to put the full developer >edition on a computer just to get the replication manager tool, but this >is a MS product. > > > > From the ADH it looks like I could do everything through use of the Jet > Replication Object and some code, but I was looking for a user friendly > way of doing this. Have you had any experience with managing > synchronization this way? > > > >Doug > > > > > > > >-----Original Message----- >From: accessd-admin at databaseadvisors.com >[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Charlotte Foust >Sent: Thursday, March 20, 2003 12:57 PM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Access XP Developer and replication manager > > > >Replication manager is an administrative tool, not an end user tool. The >users of your app will be able to synchronize without any kind of >replication manager because replicas have the capability of synchronizing >built in. > > > >Charlotte Foust > >-----Original Message----- >From: Doug Murphy [mailto:doug at murphyscreativity.com] >Sent: Thursday, March 20, 2003 12:54 PM >To: accessd at databaseadvisors.com >Subject: [AccessD] Access XP Developer and replication manager > >Hi List, > >I have what seem like a simple question but I don't seem to be able to >find the answer. I have Office XP Developer. I am looking at the use of >replication to keep several users synchronized on a really slow network >plus be able to synchronize lap tops when they dial in. I got interested >in this method after reading Arthur Fuller's article in "Inside Microsoft >Access", March edition. I also read the chapter in the ADH on replication >to get additional information. What I have been trying to determine is >can I distribute the Replication Manager tool that comes with the >Developer Edition with my database. It seems like this is the easiest way >to set up the replication and synchronization schedule on the users >system. I found an article on the web for access 97 that seems to >indicate that Replication Manager is distributable but nothing on XP and >have found nothing in any of my XP literature of help files. > >Has anyone had experience with this tool and been able to distribute it or >does the user need to have the MOD on their machine? > >Thanks in advance for your assistance. > >Doug -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030320/8927efc6/attachment-0001.html>