<!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.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>