Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    49

    Unanswered: finding out what reports/forms/etc. use a query

    Ms Access 2003. Is there any way to find out what is using a certain query?
    I need to know if qryPFP is used by other reports or forms before changing it. I don't want to mess up anything else somewhere else. Does this make sense? We have a LOT of forms, queries and reports and it's hard to plow through everything.

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Try renaming it. If used something will fall apart.

    Or, check the datasource of all your forms, subforms, charts, reports, etc. make a list and clean house accordingly. And then rename it with "isUn" or similar on the front for unused, just incase you miss some control that may use it.

    Also, use a right click on your queries and enter table names which are using it in the description. This will flag the used ones.

Posting Permissions

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