Connecting Tech Pros Worldwide Help | Site Map

Access queries: frequently used queries

  #1  
Old November 17th, 2008, 04:05 PM
dwwalcott@gmail.com
Guest
 
Posts: n/a
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.
  #2  
Old November 18th, 2008, 11:25 AM
Allen Browne
Guest
 
Posts: n/a

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.
  #3  
Old November 18th, 2008, 01:15 PM
paii, Ron
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection pooling issue with pass through queries Bill E. answers 12 June 27th, 2008 08:26 PM
Connection pooling issue with pass through queries Bill E. answers 9 June 1st, 2008 10:45 PM
access 97, insert from sql server slow lesperancer@natpro.com answers 21 January 5th, 2007 04:15 PM
Article : Code Access Security Part - 1 (.Net FrameWork Tools Series) Namratha Shah \(Nasha\) answers 0 November 17th, 2005 03:39 PM