Access queries: frequently used queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dwwalcott@gmail.com
    #1

    Access queries: frequently used queries

    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.
    Tags: None
    • Allen Browne
      #2
      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@gmai l.comwrote in message
      news:c91c612f-0b5e-4dad-9a08-d2da5b0d835f@i1 8g2000prf.googl egroups.com...
      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.

        Comment

        • paii, Ron
          #3
          Re: Access queries: frequently used queries


          <dwwalcott@gmai l.comwrote in message
          news:c91c612f-0b5e-4dad-9a08-d2da5b0d835f@i1 8g2000prf.googl egroups.com...
          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.


            Comment

            Previous template Next
            Working...