Connecting Tech Pros Worldwide Forums | Help | Site Map

Access queries: frequently used queries

dwwalcott@gmail.com
Guest
 
Posts: n/a
#1: Nov 17 '08
Is there a way to determine the last time a query was used? I would
like to see a "Last used on" list to help determine which old queries
are no longer being used.

Allen Browne
Guest
 
Posts: n/a
#2: Nov 18 '08

re: Access queries: frequently used queries


No. Access does not keep a log of when your queries are used.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dwwalcott@gmail.comwrote in message
news:c91c612f-0b5e-4dad-9a08-d2da5b0d835f@i18g2000prf.googlegroups.com...
Quote:
Is there a way to determine the last time a query was used? I would
like to see a "Last used on" list to help determine which old queries
are no longer being used.
paii, Ron
Guest
 
Posts: n/a
#3: Nov 18 '08

re: Access queries: frequently used queries



<dwwalcott@gmail.comwrote in message
news:c91c612f-0b5e-4dad-9a08-d2da5b0d835f@i18g2000prf.googlegroups.com...
Quote:
Is there a way to determine the last time a query was used? I would
like to see a "Last used on" list to help determine which old queries
are no longer being used.
Assuming you have a main form to execute you application. Write a log to a
table in the procedures executing the queries.


Closed Thread