Charlotte Foust
cfoust at infostatsystems.com
Thu Mar 20 16:08:01 CST 2003
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 user's 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/231b85b1/attachment-0001.html>