<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=472313714-14082003><FONT face=Arial color=#0000ff size=2>And
once you agree to touch it it becomes "yours" so it is always better to deal
with issues straight up on the frond end. Easy advice to give but often hard to
do when the customer doesn't want to hear it. Good
Luck</FONT></SPAN></DIV>
<DIV><SPAN class=472313714-14082003><FONT face=Arial color=#0000ff size=2>Jim
Hale</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> John Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> Thursday, August 14, 2003
8:39 AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] Summer Intern
Software:(<BR><BR></FONT></DIV>
<DIV><SPAN class=128283813-14082003><FONT face=Arial color=#0000ff size=2>All
you can do is tell the truth, be tactful and try not to step on toes, but be
firm about the requirements.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<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>Nancy
Lytle<BR><B>Sent:</B> Thursday, August 14, 2003 8:30 AM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> [AccessD]
Summer Intern Software:(<BR><BR></FONT></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2> f>>>>ine piece of summer intern
engineering.<<<<</FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2>Boy, does that have me laughing and crying right
now.</FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff size=2>I
have just been given a database that was developed by a summer intern who
had absolutely no experience with Access before he started this
project. There is no documentation, except for some sheet laying out
of schedule of when milestones were to be met. </FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2>And I was told it should be ready to give to the users within a week.
Well it has been a week now and I am discovering some major issues,
fields are named inconsistently across the database (trans_num in one table,
doc_num in another - they are supposed to be the same thing), there 9
different queries, 9 reports with the only difference being the year and
category.., plus other duplicates of reports, queries and tables, no
relationships were set up, and although the database is for financial
analysis of money into and out of projects and tasks
within projects, I can find no code that actually updates the data in
the tables, just some code in the reports. I am going
crazy.</FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2>Have any of you (or most) run into this type of situation. If
so how to you make the client realize that if they want a database that
works there will need to be some major revamping needed that will take some
time.</FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2>The client thinks it works okay, but that is because she is testing
it with static data and not testing it dynamically by doing data
entry.</FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2>TIA,</FONT></SPAN></DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2>Nancy </FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=862570112-14082003><FONT face=Arial color=#0000ff
size=2><BR>---<BR>Outgoing mail is certified Virus Free.<BR>Checked by AVG
anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version:
6.0.509 / Virus Database: 306 - Release Date:
8/12/2003</FONT></SPAN></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>