Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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!
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page