Old queries / views

  • 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.
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top