[AccessD] Estimating Help

...by "garbage" I assume you mean incorrectly entered data such as names, 
addresses, etc ...and that once the cleanup is completed, then you will 
archive the oldest data.

...garbage cleanup is the hardest thing I do for new clients ...they want 
"perfection" and that is often damn hard to achieve ...so I look at their 
data ...really look at it ...then I make a WAG as to how many hours it will 
take me ...then I quadruple that WAG ...because the WAG is ALWAYS low ...and 
although I want the business, I have bills to pay.

...one suggestion ...I've found that using Dave Bell's Proper Case mdb 
(www.colbyconsulting.com) is really a major help in this kind of work 
...forget its name and look at all its capable of doing in a garbage filled 
db ...HTH :)

William


>From: "Jeff Barrows" <outbak at wi.rr.com>
>Reply-To: accessd at databaseadvisors.com
>To: <accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Estimating Help
>Date: Fri, 31 Jan 2003 07:09:05 -0600
>
>Sorry, I should have been a little more specific.  I have a new client
>with a split database (FE & BE) and they need to clean up all the
>garbage data in the BE.  They have at least 5 years of active data which
>will soon be 3 years (archiving the rest).  Does anyone have a 'formula'
>to estimate the garbage cleanup time?
>
>Thanks
>
>Jeff Barrows
>Outbak Technologies, LLC
>Racine, WI
>Phone: (262) 634-0653
>Mailto: jeff_developer at hotmail.com
>www.outbak-technologies.com
>ICQ # 8739060
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail