Identifying old forms not used

[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.

 

[John Vinson]

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.

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