[AccessD] Global table changes

jmoss111 jmoss111 at bellsouth.net
Sun Sep 21 16:23:03 CDT 2003


I thought that you might have gotten your copy from some place other than directly from the vendor. Sometimes you can get a better price from Programmers Paradise or some 3rd party. In fact I looked at Programmers Paradise and they didn't have Speed Ferret.

Thanks,

Jim
  ----- Original Message ----- 
  From: William Hindman 
  To: Access Developers discussion and problem solving 
  Sent: Sunday, September 21, 2003 3:13 PM
  Subject: Re: [AccessD] Global table changes


  ...sorry Jim, you're right ...I used an upgrade to get mine and didn't pay enough attention to the current full price :(

  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: jmoss111 
    To: Access Developers discussion and problem solving 
    Sent: Sunday, September 21, 2003 1:08 PM
    Subject: Re: [AccessD] Global table changes


    William,

    Where did you find SF for $169, their web site quotes $199? But with all things considered I think that I'd be better off with a subscription, because when they release an Access 11 version, it would cost another $100 to get the latest version.

    I'm going to downloaf both SF and F & R and try them out. I do like the advantage that SF has with the ability to do SQL 2000 in addition to multiple flavors of Access. 

    Anyway, many thanks to those who responded.

    Jim
      ----- Original Message ----- 
      From: William Hindman 
      To: Access Developers discussion and problem solving 
      Sent: Saturday, September 20, 2003 7:23 PM
      Subject: Re: [AccessD] Global table changes


      ...ach!!! its www.moshannon.com :(((((

      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: William Hindman 
        To: Access Developers discussion and problem solving 
        Sent: Saturday, September 20, 2003 8:17 PM
        Subject: Re: [AccessD] Global table changes


        ...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



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


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


More information about the AccessD mailing list