David Emerson
davide at dalyn.co.nz
Mon Nov 3 12:14:50 CST 2003
Have you considered indirect synchronization. Basically the remote users have dropboxes set up on the server. They dial into the server and do their synchronization when they are ready. Check out the replication white papers etc for information. Here is a list of some resources for A97 (not sure if the links still work). Updated copies of most of them are available for A2K and A02 - Building Applications with Microsoft Access 97 Access 97 Developers Handbook (Litwin, Getz, Gilbert) Database Replication in Microsoft Jet (Tony Poll - Microsoft Replication White Paper) http://support.microsoft.com/default.aspx?scid=kb;en-us;Q164553 Microsoft Jet Database Replication (Peter Bateman, Bruce Schatzman) Microsoft Access 97 Replication Site http://support.microsoft.com/default.aspx?scid=/support/access/content/repl/replication.asp Internet Synchronization with Microsoft Jet 3.5 (Michael Wachal) http://support.microsoft.com/default.aspx?scid=kb;en-us;Q181371 Search for replication here http://msdn.microsoft.com/default.asp Microsoft Knowledgebase Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205 At 3/11/2003, you wrote: >Dear Group, > >I've been enlightened by Michael Kaplan's explanation of the perils of >copying replicas and not going through a proper replication sequence with >CD copies back and forth. > >The question is: what now? The independent laptops are scattered around >the state and its *very* inconvenient for them to come back to do a >physical replication. Money to write a custom synchronization process is >simply not available. > >I note from Kaplan's explanations that if the replicas are unmanaged -- >that is, Synchronizer is not used -- then certain types of problems can be >avoided. Also problems can be avoided by using the built-in Access methods >for moving replicas or by using TSI Synchronizer. > >He also mentions using the Briefcase reconciler, but that doesn't exist in >Windows 2000 or XP, does it? > >I'm trying to avoid creating a mess. The application is in more or less a >beta stage now, so we could start from scratch with a new Replication >strategy. Any advice? > >Regards, > >Steve Erbach >Scientific Marketing >Neenah, WI > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com