<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6389.0">
<TITLE>RE: [AccessD] Replication - A2K</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">John,</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">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 COLOR="#0000FF" SIZE=2 FACE="Arial">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 COLOR="#0000FF" FACE="Arial">Charles Wortz</FONT></B>
<BR><FONT COLOR="#0000FF" FACE="Arial">Software Development Division</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">Texas Education Agency</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">1701 N. Congress Ave</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">Austin, TX 78701-1494</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">512-463-9493</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">CWortz@tea.state.tx.us</FONT>
</P>
<BR>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd-bounces@databaseadvisors.com [</FONT><A HREF="mailto:accessd-bounces@databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:accessd-bounces@databaseadvisors.com</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT><B> <FONT SIZE=1 FACE="Tahoma">On Behalf Of</FONT></B> <FONT SIZE=1 FACE="Tahoma">John W. Colby</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Friday 2003 Mar 28 09:21</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd@databaseadvisors.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">RE: [AccessD] Replication - A2K</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">So rather than saying "this solution doesn't work", why don't you suggest a solution that does?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: accessd-bounces@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">[</FONT><A HREF="mailto:accessd-bounces@databaseadvisors.com]On"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:accessd-bounces@databaseadvisors.com]On</FONT></U></A><FONT SIZE=2 FACE="Arial"> Behalf Of Wortz, Charles</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Friday, March 28, 2003 8:33 AM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: RE: [AccessD] Replication - A2K</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">John,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">But what about the situation where a customer calls back five minutes</FONT>
<BR><FONT SIZE=2 FACE="Arial">later with additional information and gets a different examiner? How is</FONT>
<BR><FONT SIZE=2 FACE="Arial">the second examiner going to be able to get to the customer's data if</FONT>
<BR><FONT SIZE=2 FACE="Arial">you replicate on a 15 minute schedule? This may not be a common</FONT>
<BR><FONT SIZE=2 FACE="Arial">occurrence, but it does happen and you need to be able to handle it.</FONT>
<BR><FONT SIZE=2 FACE="Arial">And don't expect the customer to remember the name of the first</FONT>
<BR><FONT SIZE=2 FACE="Arial">examiner, that solution is a non-starter.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Charles Wortz</FONT>
</P>
</BODY>
</HTML>