<!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=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></FONT></CODE></BODY></HTML>