Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Where-Used Documentor (97/2k)

    I have inherited an Access database for Maintenance purposes. And of course there is little or no documentation or comments in the code. (Surprise Surprise). There are quite a number of Queries, Forms, Tables and Macros, which appear to be surplus to requirements. At least I cant find where they are used. I am reluctant to delete them in case I damage the database, but need to understand what they are for. The MS Access documentor only looks at the structure by analysing tables queries reports etc, but does not tell me where they are used.

    Can anyone advise where I can get some kind of reverse documentor that will help ??

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

    Re: Where-Used Documentor (97/2k)

    Two products come to mind. The first is Total Access which is available from FMS, Inc. I believe. It will document things from soup to nuts, and has a cross-reference report which shows what is used where. It does however cost a bit more than a product call Speed Ferrett. The latter will find everywhere that a specific text string is used. So you have to go through items one by one and determine if and where they are used. (It also will rename things globally in Access 97). There are also some shareware/freeware tools out there that have some basic capabilities, but I haven't used them.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Where-Used Documentor (97/2k)

    Wendell,
    I know this is an old post, but I found an Add-In which appears to fit the bill. The best part is that it is freeware. The product is called NJHtools
    the URL is http://home.wanadoo.nl.

    It also has lots of other tools. Have only looked at the Where used listing, (It creates a table) But it gives a cross reference of where objects are used. Just what I wanted.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Where-Used Documentor (97/2k)

    check out ezy documentor by www.aadconsulting.cjb.net
    It is also free and they also have a bunch of other free tolls

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

    Re: Where-Used Documentor (97/2k)

    I looked at that link, but could not find any mention of the add-in you referred to. The software link took me to tucows, but the NJHtools wasn't to be found there either. You might want to post a more specific link.
    Charlotte

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where-Used Documentor (97/2k)

    Hi Devious

    In addition to all the other suggestions, I always find it helpful to sit down with end users and document their daily, monthly, etc. procedures. This will hopefully lead you to switchboards, menus and other hoops they jump through to get the job done. This will also allow you tell which objects are not being used.

    Better yet have the operators document their own procedures and you can verify, this can be the basis of a user manual that will documnt the system and be used as a training tool for new users.

    HTH

    John

  7. #7
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Where-Used Documentor (97/2k)

    This is strange Charlotte, the link appears to be different to what I remember posting yesterday. Hmmm maybe my memory is going.

  8. #8
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where-Used Documentor (97/2k)

    Try here:

    http://home.wanadoo.nl/njh/download_tools97.htm

    Edited by Charlotte to activate link

Posting Permissions

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