<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [AccessD] Replication - A2K</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff size=2>Hi
Jim:</FONT></SPAN></DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff size=2>Thank
you very much for that information. Bare with me for a while and I will see if I
can dig up any information on the tests ran. Unfortunately, the tests never
developed into a full project. I suspect most of the original detail was
lost; I do remember that there was some issues but at one point the
connection stabilized. The test bed was two computers, each with different BE
databases, one Master, one Replicate and it looped out to our ISP and back
again. (It might have been through a VPN connection but as a company
developer I was not involved with the infrastructure.) </FONT></SPAN></DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff size=2>Arthur
Fuller did a project on replication a few years back and it sounded
quite successful. I am again not sure of any details so Arthur would have
to provide those.</FONT></SPAN></DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff size=2>Sorry
that I can not be of more help</FONT></SPAN></DIV>
<DIV><SPAN class=560454418-31032003><FONT face=Arial color=#0000ff
size=2>Jim</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Jim
DeMarco<BR><B>Sent:</B> Monday, March 31, 2003 9:38 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Replication -
A2K<BR><BR></FONT></DIV>
<DIV><SPAN class=654063517-31032003><FONT face=Arial color=#0000ff size=2>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></SPAN></DIV>
<P><FONT face=Arial size=2>Thanks,</FONT> </P>
<P><FONT face=Arial size=2>Jim DeMarco</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jim Lawrence (AccessD)
[mailto:accessd@shaw.ca]<BR><B>Sent:</B> Monday, March 31, 2003 11:36
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Replication - A2K<BR><BR></FONT></DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff size=2>Hi
Jim:</FONT></SPAN></DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff
size=2>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></SPAN></DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff size=2>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></SPAN></DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=650361016-31032003><FONT face=Arial color=#0000ff
size=2>Jim</FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=650361016-31032003><FONT
face=Arial color=#0000ff></FONT></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=650361016-31032003> </SPAN>---Original
Message-----<BR><B>From:</B> accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Jim
DeMarco<BR><B>Sent:</B> Monday, March 31, 2003 5:38 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Replication -
A2K<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE>
<DIV><SPAN class=730373613-31032003><FONT face=Arial color=#0000ff
size=2>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></SPAN></DIV>
<P><FONT face=Arial size=2>Thanks,</FONT> </P>
<P><FONT face=Arial size=2>Jim DeMarco</FONT> <BR><FONT face=Arial
size=2>Director of Product Development</FONT> <BR><FONT face=Arial
size=2>HealthSource/Hudson Health Plan</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jim Lawrence (AccessD)
[mailto:accessd@shaw.ca]<BR><B>Sent:</B> Saturday, March 29, 2003 7:03
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Replication - A2K<BR><BR></FONT></DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2>Hi John:</FONT></SPAN></DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2>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></SPAN></DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2>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></SPAN></DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2><STRONG>There simply is no other inexpensive solution</STRONG>.
The cost is either on a expensive product or an expensive programming
process.</FONT></SPAN></DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=460394011-29032003><FONT face=Arial color=#0000ff
size=2>Jim</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>John
W. Colby<BR><B>Sent:</B> Friday, March 28, 2003 8:29 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Replication - A2K<BR><BR></FONT></DIV>
<DIV><SPAN class=106272016-28032003><FONT face=Arial color=#0000ff
size=2>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></SPAN></DIV>
<DIV><SPAN class=106272016-28032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=106272016-28032003><FONT face=Arial color=#0000ff
size=2>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></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of
</B>Wortz, Charles<BR><B>Sent:</B> Friday, March 28, 2003 11:10
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Replication - A2K<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial color=#0000ff size=2>John,</FONT> </P>
<P><FONT face=Arial color=#0000ff size=2>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.</FONT></P>
<P><FONT face=Arial color=#0000ff size=2>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.</FONT></P>
<P><B><FONT face=Arial color=#0000ff>Charles Wortz</FONT></B>
<BR><FONT face=Arial color=#0000ff>Software Development
Division</FONT> <BR><FONT face=Arial color=#0000ff>Texas Education
Agency</FONT> <BR><FONT face=Arial color=#0000ff>1701 N. Congress
Ave</FONT> <BR><FONT face=Arial color=#0000ff>Austin, TX
78701-1494</FONT> <BR><FONT face=Arial
color=#0000ff>512-463-9493</FONT> <BR><FONT face=Arial
color=#0000ff>CWortz@tea.state.tx.us</FONT> </P><BR>
<P><FONT face=Arial></FONT> <FONT face=Tahoma
size=1>-----Original Message-----</FONT> <BR><B><FONT face=Tahoma
size=1>From: </FONT></B> <FONT face=Tahoma
size=1>accessd-bounces@databaseadvisors.com [</FONT><A
href="mailto:accessd-bounces@databaseadvisors.com"><U><FONT
face=Tahoma color=#0000ff
size=1>mailto:accessd-bounces@databaseadvisors.com</FONT></U></A><FONT
face=Tahoma size=1>] </FONT><B> <FONT face=Tahoma size=1>On
Behalf Of</FONT></B> <FONT face=Tahoma size=1>John W. Colby</FONT>
<BR><B><FONT face=Tahoma size=1>Sent: </FONT></B> <FONT
face=Tahoma size=1>Friday 2003 Mar 28 09:21</FONT> <BR><B><FONT
face=Tahoma size=1>To: </FONT></B> <FONT
face=Tahoma size=1>accessd@databaseadvisors.com</FONT> <BR><B><FONT
face=Tahoma
size=1>Subject: </FONT></B>
<FONT face=Tahoma size=1>RE: [AccessD] Replication - A2K</FONT> </P>
<P><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.</FONT></P>
<P><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.</FONT></P>
<P><FONT face=Arial size=2>So rather than saying "this solution
doesn't work", why don't you suggest a solution that does?</FONT>
</P>
<P><FONT face=Arial size=2>John W. Colby</FONT> <BR><FONT face=Arial
size=2>Colby Consulting</FONT> <BR><A
href="file://www.ColbyConsulting.com"><U><FONT face=Arial
color=#0000ff size=2>www.ColbyConsulting.com</FONT></U></A> </P>
<P><FONT face=Arial size=2>-----Original Message-----</FONT>
<BR><FONT face=Arial size=2>From:
accessd-bounces@databaseadvisors.com</FONT> <BR><FONT face=Arial
size=2>[</FONT><A
href="mailto:accessd-bounces@databaseadvisors.com]On"><U><FONT
face=Arial color=#0000ff
size=2>mailto:accessd-bounces@databaseadvisors.com]On</FONT></U></A><FONT
face=Arial size=2> Behalf Of Wortz, Charles</FONT> <BR><FONT
face=Arial size=2>Sent: Friday, March 28, 2003 8:33 AM</FONT>
<BR><FONT face=Arial size=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT face=Arial size=2>Subject: RE: [AccessD] Replication -
A2K</FONT> </P><BR>
<P><FONT face=Arial size=2>John,</FONT> </P>
<P><FONT face=Arial size=2>But what about the situation where a
customer calls back five minutes</FONT> <BR><FONT face=Arial
size=2>later with additional information and gets a different
examiner? How is</FONT> <BR><FONT face=Arial size=2>the second
examiner going to be able to get to the customer's data if</FONT>
<BR><FONT face=Arial size=2>you replicate on a 15 minute
schedule? This may not be a common</FONT> <BR><FONT face=Arial
size=2>occurrence, but it does happen and you need to be able to
handle it.</FONT> <BR><FONT face=Arial size=2>And don't expect the
customer to remember the name of the first</FONT> <BR><FONT
face=Arial size=2>examiner, that solution is a non-starter.</FONT>
</P>
<P><FONT face=Arial size=2>Charles Wortz</FONT> </P></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>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></DIV></BLOCKQUOTE></BLOCKQUOTE><CODE><FONT
size=3><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></BLOCKQUOTE></BLOCKQUOTE></FONT></CODE><CODE><FONT
size=3><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></BLOCKQUOTE></FONT></CODE></BODY></HTML>