Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Tracing Object References

Discussion in 'Information Technology' started by BarryC, Nov 10, 2005.

  1. BarryC

    BarryC
    Expand Collapse
    Guest

    Is there a way to find all references to an object in an Access
    database?

    For instance, I need to find all occurances of Query1 - every macro,
    report, form or query that references it.

    It would be nice to be able to do this with fields too.

    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Tracing the Spark of Creative Problem-Solving Breaking News Dec 13, 2010
    Sikh News Retracing the glory of Shah Mohammad Breaking News Dec 12, 2005
    Defining a Sikh : Tracing the Historic Foundations of Sikh Identity. Essays on Sikhism Dec 9, 2004
    Sikh Weddings Crashed by Protestors Objecting to Mixed Faith Marriages Sikh Sikhi Sikhism Mar 12, 2013
    Sikh Body AISSF Objects to Hindi TV Serial, Gurbani Hard Talk Mar 11, 2013

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Take a look at Total Access Analyzer from FMS
    http://www.fmsinc.com/products/analyzer/index.html

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "BarryC" <barryecole@netscape.net> wrote in message
    news:1131554666.618442.127040@z14g2000cwz.googlegroups.com...
    > Is there a way to find all references to an object in an Access
    > database?
    >
    > For instance, I need to find all occurances of Query1 - every macro,
    > report, form or query that references it.
    >
    > It would be nice to be able to do this with fields too.
    >
    > Thanks!
    >
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Use Access ANALYZE - Documentor and select all forms, reports, etc. Save to
    Word
    and do a find for the object.


    "BarryC" wrote:

    > Is there a way to find all references to an object in an Access
    > database?
    >
    > For instance, I need to find all occurances of Query1 - every macro,
    > report, form or query that references it.
    >
    > It would be nice to be able to do this with fields too.
    >
    > Thanks!
    >
    >
     

Share This Page