Old queries / views

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

 

[[MVP] S.Clark]

The msysobjects table holds the Date Created and Modified.

Total Access Analyzer will alert you to any query not used in another
object.
http://www.fmsinc.com/products/analyzer/index.html

The caveat being that if a query is called in code, that it will not be
picked up.

For example:
strSQL = "Select * from qryStuff WHERE StuffID = " & cboStuffID
msgbox DCount("*", strSQL)

This code would flag the query qryStuff as being used.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-