[AccessD] Cross Reference Utility, was RE: New engagement; trying to avoid the "tip of the iceberg" consulting trap

David McAfee davidmcafee at gmail.com
Tue Nov 9 12:48:29 CST 2010


I never knew this existed in MZ Tools.


Does this check the whole project, or only the current module?



On Tue, Nov 9, 2010 at 7:36 AM, Heenan, Lambert
<Lambert.Heenan at chartisinsurance.com> wrote:
> MZ Tools will do that for you.
>
>  http://www.mztools.com/index.aspx
>
> Right Click anywhere in a code module and select "Review Source code" from the MZ Tools menu.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Tuesday, November 09, 2010 9:38 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Cross Reference Utility, was RE: New engagement; trying to avoid the "tip of the iceberg" consulting trap
>
> A related questions - I am cleaning up a form which, after its cleaned will have a lot of variables DIMmed which are no longer needed.  Does anyone know of a some kind of utility that will display all the variables which are no longer referenced anywhere?
>
> TIA
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
> Sent: Tuesday, November 09, 2010 5:03 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] New engagement; trying to avoid the "tip of the iceberg" consulting trap
>
>
>  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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> 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