title: MS Access 2007: Find Where a Form / Query / Report is Used
body: <p><b>History:</b> I inherited a rather large app written using MS Access with lots of forms, queries, and reports. Because it looks like some of these items that were copied as a way of backing them up, I've got no idea if they are actually used anywhere.</p>
  
  <p><b>Question:</b> I am starting the process of cleaning up the app and need a way to find if and where forms, reports, or queries are used so that I know if I can delete or refactor them. Is there a good way have Access search the events of buttons for the names of forms / reports?</p>
  
  <p>(Access' find feature seems to find only records unless I'm missing a setting)
  <br><br><br>
  <b>Edit - Solutions:</b></p>
  
  <p>1.) As has been mentioned in the answers and comments below, it would be a valuable lesson to rebuild the application by creating a fresh Access file then going form by form, starting with the login screen, and seeing what is missing. This would provide great insight into the whole application.</p>
  
  <p>2.) I found <a href="https://stackoverflow.com/questions/1093475/search-for-field-references-within-a-microsoft-access-application">this post</a> that discusses using the "Database Documenter" to dump out all of the information relating to the objects, VBA, etc used in a given form. The resulting text file is easily searchable for the use of a single particular query, report, or form. It would not provide me with the same level of knowledge as re-building the whole application would, but it is a good stop-gap measure for targeted knowledge / possible cleanup.</p>