Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cross Ref Tool Wanted (Access 2000)

    I have inherited an Access database containing many reports, queries and tables. I have not been provided with any documention.

    I would like to be able to see, at a glance, which tables are used for what queries which are, in turn, used for what reports.

    Does anyone know of such a tool (preferably one that falls into the freeware category)?

    TIA.
    Carol W.

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

    Re: Cross Ref Tool Wanted (Access 2000)

    I don't know of a good freeware one - the most comprehensive one available is from FMS (http://www.fmsinc.com/products/analyzer/index.html. Tools like Speed Ferrett can also be used to do some of this stuff, but they don't produce any sort of cross-reference or "used-on" report.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cross Ref Tool Wanted (Access 2000)

    Thanks for the recommendation, Wendell. I may give the trial version a try.
    Carol W.

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

    Re: Cross Ref Tool Wanted (Access 2000)

    (Edited by HansV to activate URL - see <!help=19>Help 19<!/help>)

    Maybe try this also :

    Ezy Documenter Wizard for Access97 Version 4.5
    Ezy Documenter Wizard for Access2000/XP Version 4.5

    This add-in for Access automatically documents and prints in a fully formatted Access report all the major objects in your Access database: tables and fields, table relations, query definitions, forms and record sources, reports and record sources, all code modules, all macros, all data access pages, and all references

    It can be found at :
    http://www.aadconsulting.com/ezydoc.html

    Zave

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cross Ref Tool Wanted (Access 2000)

    Thanks, Zave.

    I found that by running the aadconsulting reports and exporting them to several Excel worksheets, I can sort the data and almost <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> get the info I need.
    Carol W.

Posting Permissions

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