Results 1 to 3 of 3
  1. 01-10-2011, 07:41 AM #1
    Grooz13
    Grooz13 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    97

    Smile How to know if a query is used

    is there any to know which query is used and which is not so i can clean my db ?
    Reply With Quote Reply With Quote
  2. 01-10-2011, 09:02 AM #2
    ssanfu
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by Grooz13 View Post
    is there any to know which query is used and which is not so i can clean my db ?
    What I do is change the name of the saved query (add a "z_" to the name), then open the forms/reports. If there are no errors, the query is probably not used. Keep the query for a while or move it to a backup mdb, just in case.

    There are a couple of programs that will document your mdb, telling you where an object is referenced. I'll look to see if I can find them....
    Reply With Quote Reply With Quote
  3. 01-10-2011, 12:35 PM #3
    Grooz13
    Grooz13 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    97
    thx it was a good solution, always do a back up first too thx
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums