tracing queries that are not used

[pkeegs]

I have a huge number of queries in an access database that I use, I am sure
that some are not required. I am reluctant to simply delete them and then see
if everything is working. Is there a way of tracing whether there are any
reports etc that are dependent on a particular query - as with auditing for
precedents and dependents in Excel.

Regards

 

[John W. Vinson]

I have a huge number of queries in an access database that I use, I am sure
that some are not required. I am reluctant to simply delete them and then see
if everything is working. Is there a way of tracing whether there are any
reports etc that are dependent on a particular query - as with auditing for
precedents and dependents in Excel.

Regards

Not very easily, alas! There are some thirdparty tools that let you do this:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

Total Access Analyzer has a very good dependency analysis report. Last I
heard, though, it's available only up through Access2002, not yet for 2003 or
2007.

John W. Vinson [MVP]

 

[Tom Wickerath]

Hi John,

Total Access Analyzer has a very good dependency analysis report. Last I
heard, though, it's available only up through Access2002, not yet for 2003 or
2007.

SpeedFerret is currently only available through Access 2002. Total Access
Analyzer is currently available for versions of Access up to Access 2003.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[John W. Vinson]

Hi John,


SpeedFerret is currently only available through Access 2002. Total Access
Analyzer is currently available for versions of Access up to Access 2003.

Thanks Tom - misremembered!

John W. Vinson [MVP]

 

[pkeegs]

Thanks all for the replies - I will work through the options and see what
turns up.