<html>
<body>
A97 replication works over the internet but you need to allow anonymous
users to log in - this opens the server to all and sundry who will do all
sorts of undesirable things to it.<br><br>
We use VPN over a dial up network and it works ok. We use indirect
synchronization to protect the data files from corruption over the
lines.<br><br>
David Emerson<br>
Dalyn Software<br>
New Zealand<br><br>
At 31/03/2003, you wrote:<br>
<blockquote type=cite class=cite cite><font face="arial" size=2 color="#0000FF">I
believe we couldn't get A97 to replicate over the Internet at all so we
tried converting the app to A2K2 and that would only work over VPN.
We had a developer talk to M$ on the phone or via e-mail for a week or
two and the VPN was the only way it would work (M$ could not get
replication to work over the Internet either, FYI). If you had a
non-VPN replication working do you have any "secrets" to
share?</font><br><br>
<font face="arial" size=2>Thanks,</font> <br><br>
<font face="arial" size=2>Jim DeMarco</font> <br>
<dl>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> Jim Lawrence (AccessD)
[<a href="mailto:accessd@shaw.ca" eudora="autourl">mailto:accessd@shaw.ca</a>]<br>
<dd>Sent:</b> Monday, March 31, 2003 11:36 AM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Replication - A2K<br><br>
</font>
<dd><font face="arial" size=2 color="#0000FF">Hi Jim:</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">No, the Access97
replication is done straight through the phone lines. The government has
been using it's own internal network, first through fast dedicated phone
lines and finally an 'Ubiquity' fiber-optic connection that now covers
most of the province. I have ran Access97 through the net and noticed no
major problems but it was only a test and not under full
load.</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">It should be stable in the
current versions of Access, even running across the net. VPN would be
good to secure the connections but I am not sure that it would be any
more or less stable than a standard internet connection.</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">Jim</font><br>
<dd> <br>
<dd><font face="tahoma" size=2> ---Original Message-----<br>
<dd>From:</b> accessd-bounces@databaseadvisors.com
[<a href="mailto:accessd-bounces@databaseadvisors.com" eudora="autourl">mailto:accessd-bounces@databaseadvisors.com</a>]On
Behalf Of </b>Jim DeMarco<br>
<dd>Sent:</b> Monday, March 31, 2003 5:38 AM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Replication - A2K<br><br>
</font>
<dd><font face="arial" size=2 color="#0000FF">Jim are you doing Internet
replication then? If so are you using a VPN? We've
encountered some difficulties in running replication over the Net on
A97. Which version are you using?</font><br><br>
<dd><font face="arial" size=2>Thanks,</font> <br><br>
<dd><font face="arial" size=2>Jim DeMarco</font> <br>
<dd><font face="arial" size=2>Director of Product Development</font>
<br>
<dd><font face="arial" size=2>HealthSource/Hudson Health Plan</font> <br>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> Jim Lawrence (AccessD) [<a href="mailto:accessd@shaw.ca" eudora="autourl">mailto:accessd@shaw.ca</a>]<br>
<dd>Sent:</b> Saturday, March 29, 2003 7:03 AM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Replication - A2K<br><br>
</font>
<dd><font face="arial" size=2 color="#0000FF">Hi John:</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">I have been running a Access replication application for five years. There are basically three government offices with about forty total individuals. The program has both an automatic and manual replication process programmed in. I have one BE db with one table that is centeral to the process. This is the file that supplies all the invoice numbers. It is linked to each site by its URL address. As soon as a ne record is created, the program goes looking for the next number. If the lines are glogged, that can take about 30 seconds.</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">I come in every so often and clean up any duplications because sometimes the timing is off. The issue only comes up once every couple months or so. The cost to permentantly resolve the problem, with a nice SQL BE, is prohibitive so the clients have settled on this type of solution.</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">There simply is no other inexpensive solution</b>. The cost is either on a expensive product or an expensive programming process.</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">HTH</font><br>
<dd><font face="arial" size=2 color="#0000FF">Jim</font><br>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> accessd-bounces@databaseadvisors.com [<a href="mailto:accessd-bounces@databaseadvisors.com" eudora="autourl">mailto:accessd-bounces@databaseadvisors.com</a>]On Behalf Of </b>John W. Colby<br>
<dd>Sent:</b> Friday, March 28, 2003 8:29 AM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Replication - A2K<br><br>
</font>
<dd><font face="arial" size=2 color="#0000FF">And perhaps the situation is simply different. People don't call to file claims, they fill out paperwork and submit it. Not that your situation won't occur, of course it will. I can certainly ask how often it occurs but having spent 8 months on site I didn't get that it happened "several times a day". People call to "check" on their claim that is already in the system - having been entered from a claim form. The folks handling the phones do take info over the phone, but mostly it is "fill out this form and mail it in", or "get your doctor to fill out this form and mail it in" or "get your employer to fill out this form and send it in". No paperwork, no claim! So people "calling back with info" simply isn't a common occurrence since they don't ask for verbal information other than current address and the likes.</font><br>
<dd> <br>
<dd><font face="arial" size=2 color="#0000FF">I will certainly advise them of the facts behind the synchronization of course. I get the feeling they will live with the occasional "out of sync" info in order to get a doubling of effective speed.</font><br><br>
<dd><font size=2>John W. Colby<br>
<dd>Colby Consulting<br>
<dd><a href="http://www.colbyconsulting.com/" eudora="autourl">www.ColbyConsulting.com</a></font> <br>
<dd><font face="tahoma" size=2>-----Original Message-----<br>
<dd>From:</b> accessd-bounces@databaseadvisors.com [<a href="mailto:accessd-bounces@databaseadvisors.com" eudora="autourl">mailto:accessd-bounces@databaseadvisors.com</a>]On Behalf Of </b>Wortz, Charles<br>
<dd>Sent:</b> Friday, March 28, 2003 11:10 AM<br>
<dd>To:</b> accessd@databaseadvisors.com<br>
<dd>Subject:</b> RE: [AccessD] Replication - A2K<br><br>
</font>
<dd><font face="arial" size=2 color="#0000FF">John,</font> <br><br>
<dd><font face="arial" size=2 color="#0000FF">I'm not saying your solution doesn't work. I pointed out a situation that will arise and that they need to have some procedure in place to handle it. Whether that procedure is within your solution or something they will have to handle manually is for them to decide.<br>
</font><br>
<dd><font face="arial" size=2 color="#0000FF">As to how often such calls occur, all I can say is when I worked for my Dad in his insurance agency it happened several times a day that somebody would call to file a claim but didn't have all the information the agent needed so they would have to call back later with the additional information. I doubt that human nature has changed much in the intervening years.<br>
</font><br>
<dd><font face="arial" color="#0000FF">Charles Wortz</b></font> <br>
<dd><font face="arial" color="#0000FF">Software Development Division</font> <br>
<dd><font face="arial" color="#0000FF">Texas Education Agency</font> <br>
<dd><font face="arial" color="#0000FF">1701 N. Congress Ave</font> <br>
<dd><font face="arial" color="#0000FF">Austin, TX 78701-1494</font> <br>
<dd><font face="arial" color="#0000FF">512-463-9493</font> <br>
<dd><font face="arial" color="#0000FF">CWortz@tea.state.tx.us</font> <br><br>
<dd> <font face="tahoma" size=1>-----Original Message-----</font> <br>
<dd><font face="tahoma" size=1>From: </b></font> <font face="tahoma" size=1>accessd-bounces@databaseadvisors.com [</font><a href="mailto:accessd-bounces@databaseadvisors.com"><font face="tahoma" size=1 color="#0000FF">mailto:accessd-bounces@databaseadvisors.com</a></u></font>] <font face="tahoma" size=1>On Behalf Of</b></font> <font face="tahoma" size=1>John W. Colby</font> <br>
<dd><font face="tahoma" size=1>Sent: </b></font> <font face="tahoma" size=1>Friday 2003 Mar 28 09:21</font> <br>
<dd><font face="tahoma" size=1>To: </b></font> <font face="tahoma" size=1>accessd@databaseadvisors.com</font> <br>
<dd><font face="tahoma" size=1>Subject: </b></font> <font face="tahoma" size=1>RE: [AccessD] Replication - A2K</font> <br><br>
<dd><font face="arial" size=2>They need an answer, and can't afford SQL Server. This is an answer. To not look at the realistic options because of the 1 in 1000 (or whatever) occurrence is not realistic.<br>
</font><br>
<dd><font face="arial" size=2>I am certainly open to other options. However they just spent 8 months moving an old creaky flat file to a relational MDB FE/BE. They don't have a budget for a $10,000 solution at the moment. What solution can they get for $500? Moving to SQl Server will be $5k or more. They don't have that, they have said so. I have done all of the typical "make sure the fields are indexed" things.<br>
</font><br>
<dd><font face="arial" size=2>So rather than saying "this solution doesn't work", why don't you suggest a solution that does?</font> <br><br>
<dd><font face="arial" size=2>John W. Colby</font> <br>
<dd><font face="arial" size=2>Colby Consulting</font> <br>
<dd><font face="arial" size=2 color="#0000FF"><a href="file://www.ColbyConsulting.com">www.ColbyConsulting.com</a></u></font> <br><br>
<dd><font face="arial" size=2>-----Original Message-----</font> <br>
<dd><font face="arial" size=2>From: accessd-bounces@databaseadvisors.com</font> <br>
<dd><font face="arial" size=2>[</font><a href="mailto:accessd-bounces@databaseadvisors.com]On"><font face="arial" size=2 color="#0000FF">mailto:accessd-bounces@databaseadvisors.com]On</a></u></font> Behalf Of Wortz, Charles <br>
<dd><font face="arial" size=2>Sent: Friday, March 28, 2003 8:33 AM</font> <br>
<dd><font face="arial" size=2>To: accessd@databaseadvisors.com</font> <br>
<dd><font face="arial" size=2>Subject: RE: [AccessD] Replication - A2K</font> <br><br>
<dd><font face="arial" size=2>John,</font> <br><br>
<dd><font face="arial" size=2>But what about the situation where a customer calls back five minutes</font> <br>
<dd><font face="arial" size=2>later with additional information and gets a different examiner? How is</font> <br>
<dd><font face="arial" size=2>the second examiner going to be able to get to the customer's data if</font> <br>
<dd><font face="arial" size=2>you replicate on a 15 minute schedule? This may not be a common</font> <br>
<dd><font face="arial" size=2>occurrence, but it does happen and you need to be able to handle it.</font> <br>
<dd><font face="arial" size=2>And don't expect the customer to remember the name of the first</font> <br>
<dd><font face="arial" size=2>examiner, that solution is a non-starter.</font> <br><br>
<dd><font face="arial" size=2>Charles Wortz</font> <br><br>
</dl><hr>
Is email taking over your day? Manage your time with eMailBoss. Try it free! <a href="http://www.eMailBoss.com">http://www.eMailBoss.com</a><br><br>
<br><br>
***********************************************************************************<br>
"This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You".<br>
***********************************************************************************<br><br>
<br><br>
***********************************************************************************<br>
"This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You".<br>
***********************************************************************************<br>
_______________________________________________<br>
AccessD mailing list<br>
AccessD@databaseadvisors.com<br>
<a href="http://databaseadvisors.com/mailman/listinfo/accessd" eudora="autourl">http://databaseadvisors.com/mailman/listinfo/accessd</a><br>
Website: <a href="http://www.databaseadvisors.com/" eudora="autourl">http://www.databaseadvisors.com</a></blockquote></body>
</html>