John Skolits
askolits at ot.com
Tue Jul 15 21:27:38 CDT 2003
The VPN is always up and running. I downloaded the TSI Synchronizer, and will use that to run indirect syncs whenever I need to. Right now they have only 1/2 of T1 line, so the connection is very slow. I will want to sync periodically, on demand. I originally designed the database to be a FE and BE design. Because of that, I wasn't worried about conflicts. Then they decided to add another office (which I didn't know about) and I have to change some of the design. In the meantime, I want to replicate only as often as I feel it's necessary. Sometimes I will replicate, when a record is saved. Sometimes even after a field update (although very rarely). The TSI Synchronizer is real easy to use so I will do resynching on demand using that code. FYI, when I started this whole process my original design is seen at this link. http://www.corporatedatadesign.com/RepIImage_01.jpg -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Haslett, Andrew Sent: Tuesday, July 15, 2003 9:32 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Replication - how can I tell if indirect occurring John, I've run a acouple of replicated environments here at work so may be able to help. First and most important question: How often do you *need* the data to be synched to your master? Secondly: What availabilty do you have for a consistent network connection between replicas, and are you willing to maintain it? Cheers, Andrew IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com