[AccessD] Global table changes

William Hindman wdhindman at bellsouth.net
Sat Sep 20 19:17:11 CDT 2003


...and I firmly disagree :)

...I use SF (Speed Ferret) from www.mosnannon.com and it plain beats the daylights out of F&R ...I just finished doing a use comparison between SF and FR (Find&Replace) because so many here had recommended it and I needed to either upgrade my version of speedferret or replace it with FR.

...the ONLY advantage F&R has is cost ...at $49 it's far cheaper than SF at $169 :(

...but FR is a serial F&R tool and its dead slow compared to SF ...I mean DEAD slow ...one use of FR and I had no question about spending the extra money to upgrade my current SF version :(

...and dear god not only is FR slow but once you've started a F&R there is no getting out short of crashing Access ...loved that! :(

...another major difference is the way SF lets you view all of the pending changes on one screen and select which to implement ...and remembers what was changed so that you can roll it back if you make a mistake ...FR has no comparable capability that I could find ...and I looked

...SF is multi platform ...one tool to run A97 thru AXP AND you get VB6 AND SQL Server capability as well ...FR is Access only and you have to load a different version for each version of Access :(

...now I know that I'm going to get a ton of FR fan mail from this list ...which is what led me to try FR in the first place ...so before you go penning your little love notes folks, do what I did and dl demos of both tools ...if after doing a side-by-side comparison you're still an FR fan, why god bless your pea-pickin' little soul cause you need it! :)

...the only fault I've ever had with SF is that they tend to be behind the power curve in getting new releases out ...it was more than six months after I had XP on my systems before they released a production SF version that worked with it :(

...but my bottom line is this ...the extra $120 SF costs is well worth the money ...that's less than two billable hours and I easily saved more than that using it rather than FR just once to make major db changes :)

William Hindman
So, then, to every man his chance -- to every man, regardless of his birth, his shining golden opportunity -- to every man his right to live, to work, to be himself, to become whatever his manhood and his vision can combine to make him -- this, seeker, is the promise of America. 
-- Thomas Wolfe 



  ----- Original Message ----- 
  From: dave sharpe 
  To: Access Developers discussion and problem solving 
  Sent: Saturday, September 20, 2003 1:21 PM
  Subject: Re: [AccessD] Global table changes


  Jim

  I agree wholeheartedly with Rocky.
  I've used since Acc95 and don't know how I'd get alone without it.
  You can get it from Rich's site http://www.rickworld.com/

  Dave

    ----- Original Message ----- 
    From: Rocky Smolin - Beach Access Software 
    To: Access Developers discussion and problem solving 
    Sent: Saturday, September 20, 2003 12:54 PM
    Subject: Re: [AccessD] Global table changes


    Jim:

    I use Rick Fisher's Find and Replace.  Free trial period but it will sell you.  I use it a lot.  It's very elegant, very complete.  Give it a try.

    Rocky

      ----- Original Message ----- 
      From: jmoss111 
      To: Access Developers discussion and problem solving 
      Sent: Saturday, September 20, 2003 7:27 AM
      Subject: [AccessD] Global table changes


      Is there a way to globally modify the name of field objects in all of the tables contained in a database?  I import anywhere from 1 to 1000 Excel spreadsheets, dbf files, mdb's or text files that contain similar data where the fields are named similarly but not uniformly. 

      Thanks,

      Jim


--------------------------------------------------------------------------


      _______________________________________________
      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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030920/2a70634b/attachment-0001.html>


More information about the AccessD mailing list