• Where-Used Documentor (97/2k)

    Author
    Topic
    #368359

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

    Viewing 2 reply threads
    Author
    Replies
    • #577002

      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.

      • #598425

        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[/url%5D.

        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.

    • #598449

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

    • #598503

      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

    Viewing 2 reply threads
    Reply To: Where-Used Documentor (97/2k)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: