<!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=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>