Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Redundant Code (A2k SR1)

    Does anyone know of a utility which sorts out redundant code ?

    When designing forms and buttons are removed or prodedures not required any more, sometimes code is left behind which doesn't relate to anything anymore.
    I would like to sift thru each form and delete this not req code.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Redundant Code (A2k SR1)

    Total Access Analyzer from FMS does this. It's not cheap, though.

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Redundant Code (A2k SR1)

    MZ Tools is good as well see <post#=147444>post 147444</post#> and its <img src=/S/free.gif border=0 alt=free width=30 height=15>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Redundant Code (A2k SR1)

    Thanks
    I've downloaded MZ and it looks excellent.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Redundant Code (A2k SR1)

    I do grant that it isn't cheap, but I like Total Access Analyzer a lot. It has excellent error checking, far more than just pointing out dead code. It's also a good tool for printing out detailed data dictionaries - in fact you need to be careful not to select too much detail (unless you like killing trees <img src=/S/smile.gif border=0 alt=smile width=15 height=15>).

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Redundant Code (A2k SR1)

    That's very true - the one negative about it is you can go through boxes of paper if you don't carefully manage what you are trying to print.
    Wendell

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Redundant Code (A2k SR1)

    Another negative is that it may lead you to think you can remove "unused" code that isn't actually unused, it's just called from the property sheet of an object rather than from within code. Some of its recommendations are strictly nit-picking. I've waded through enough of them prior to releasing a product to know how many redundancies you can get and how misleading some of its suggestions are. It isn't a bad tool, but it requires caution when using it.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •