Jim Lawrence (AccessD)
accessd at shaw.ca
Thu Dec 18 19:32:13 CST 2003
Hi Steve: There is a lot of ways to get remote synchronization. I have been able to do it with a lot of sites using various methods, for over fifteen years. DSZ and GSZ scripts with DOS to DOS, Kermit scripts PC to Mainframe, Novell server and CoSession script-files, Xenix and Dos LAN stations, Linux to Linux to LAN, PCAnywhere to LAN, Access Synchronization, Windows to VB to telnet to Server, PC to VPN to PC, SQL to SQL sync, LAN to web to web to LAN, TermServer software and hardware etc..... The one rule with remote access is that nothing is bullet-proof but at least it can be made reliable... and that is where the programmer comes in. The only issue is down to 'How soon' and How much' for there is NESS (No Easy Simple Solution). Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W. Erbach Sent: Thursday, December 18, 2003 8:15 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] "Faked" replication Martin, >> If the client has Win XP Pro then they have an IIS system there. << Alas! Alackaday! They have Win XP Home because it's cheaper. But I could persuade him to buy one copy of Pro if, indeed, what you say about IIS is true. >> FTP drop boxes? Are these folders on the IIS that the users would use to work with DBs? << Yes. In my painful journey through the intricacies of Indirect Synchronization, I've found that it's a four-step process: 1) User 1 uploads changes to his replica to Drop Box 1 on an IIS Server; 2) User 2 downloads from Drop Box 1 and merges changes with his replica; 3) User 2 now uploads his own changes to Drop Box 2; 4) User 1 downloads changes from Drop Box 2 and merges with his replica. In my initial, incomplete understanding of Indirect Synchronization I thought that one could simply set up your garden variety FTP folders any old place on the web, just so that each user had a different folder. The bane of my existence has been that Replication Manager will not accept the address of an FTP folder on the web as a valid location for a Drop Box. There are still some other details I'm fuzzy on. This whole experience has been fuzzy and frustrating. Regards, Steve Erbach Scientific Marketing Neenah, WI 920-969-0504 Message created with Bloomba Disclaimer: No tree was killed in the transmission of this message. However, several coulombs of electrons were temporarily inconvenienced. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com