Is query being used?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database that will be used by another office in my company. I am in the middle of documenting the queries and since I created the database I have made several changes and/or updates. Now I am noticing that some queries are not being used anymore. I have 168 in the database. Is there a way to determine if a query is not being run or has not been runned within a certain time frame?
 
As far as I know, there is nothing built-in to Access that will do that for
you. There is a third-party product named Total Access Analyzer that does
this very well. Here is a link:

http://www.fmsinc.com/products/analyzer/index.html

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Leisha said:
I have an access database that will be used by another office in my
Click to expand...
company. I am in the middle of documenting the queries and since I created
the database I have made several changes and/or updates. Now I am noticing
that some queries are not being used anymore. I have 168 in the database. Is
there a way to determine if a query is not being run or has not been runned
within a certain time frame?
 
Back
Top