Tracing Object References

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7023-tracing-object-references.html
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!


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7023
(no e-mails, please!)


"BarryC" wrote in message
news:1131554666.618442.127040@z14g2000cwz.googlegr oups.com...
> Is there a way to find all references to an object in an Access
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7023
> 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!
>

Use Access ANALYZE - Documentor and select all forms, reports, etc. Save to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7023
Word
and do a find for the object.


"BarryC" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7023

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