[AccessD] New engagement; trying to avoid the "tip of the iceberg" consulting trap

Jim Dettman jimdettman at verizon.net
Tue Nov 9 07:02:38 CST 2010


  Rick Fishers Find and Replace....goes a long way in cleaning up a junk DB
fast.

  Use the cross-reference utility to find all the junk that can get weeded
out right away.

  Then go back and take care of the embedded spaces and apply a prefix.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Monday, November 08, 2010 6:21 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] New engagement; trying to avoid the "tip of the
iceberg" consulting trap

So I met with the client.
Not a large application, but what a mess.
Spaces in the column names, no discipline in object names, etc, etc, .
I could go on forever.
It also has structural problems...one huge table that contains many columns
that only apply to 20% of the rows.
This begs for separate linked tables of course.

I'm giving them a 3 man-week estimate for putting a pretty face on this pig.
That's what they are really asking for....
A new menu and enhancement of the existing forms for better navigation.
Oh, and much of that work will be done at home office....they have no good
dev boxes there...
 Only these laptops with tiny, eye-tiring screens and chicklet keyboards....
 And to make matters even more miserable, it's gotta stay in Access 2007.



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
> Sent: Saturday, November 06, 2010 8:36 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] New engagement; trying to avoid the
> "tip of the iceberg" consulting trap
>
> Thanks all. Jim D. - based on that great rate that you are
> getting, I've decided to make it a fully-paid 8 hour assessment.
> After all, they're at least getting a report at the end of it.
> That'll be the deliverable.
>
> I have no idea as to what I'm walking into with this client.
> Since this engagement has been "on again", "off again",
> several times....
> I don't think that's a good sign of a "stable" client.
> This sort of conduct indicates in-fighting, budget problems,
> or other management "issues".
> I've been thru the mill over the past 2 years with IT vs. End
> user politics and let me tell you,  it really, really sucks.
>
> So after the 1 hour interview, if they don't like the "deal",
> I walk out.
> No charge.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list