Identifying old forms not used

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

We have several programmers creating queries / views and then reports and
forms. As the Database Administrator, I have seen several instances where a
query or view is created, and never used. Is there anything available
within Access or SQL that can identify if a view or query is being utilized,
and when the last time it was used? This would be helpful with forms and
reports as well.

Any help is appreciated.
 
We have several programmers creating queries / views and then reports and
forms. As the Database Administrator, I have seen several instances where a
query or view is created, and never used. Is there anything available
within Access or SQL that can identify if a view or query is being utilized,
and when the last time it was used? This would be helpful with forms and
reports as well.
Click to expand...

There isn't anything reliable built-in. To fill the vacuum there are
several good third-party programs:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace

For sale, with increasing power and cost:

Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com
 
Back
Top