Identifying Queries Not being Used in a Database.

[Keith]

I am trying to identify and delete queries that are not
being used in my database either by code or reports. Is
there any way to see the ones not being used anywhere?

 

[Craig Huggart]

Keith:

If you are willing to spend some money, you can probably find what you are
looking for at:
www.fmsinc.com

Craig Huggart
Microsoft XP Master Instructor
(e-mail address removed)

 

[Tom Ellison]

Well, it's not as neat, but you could start by renaming the queries.
Then start running the application. Whenever something doesn't work
right, find out what queries aren't working and rename them back to
their original names. Once you tested everything, the queries still
renamed are unused.

All I could do is get a demo. Does anyone know of any
other way than spending $300.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[John Spencer (MVP)]

You could download a copy of Find and Replace from www.Rickworld.com and use
that to go through your application to find all the places that your Query is
used (0ne at a time).

This is a shareware product and relatively inexpensive. Also you could get Speed
Ferret from Black Moshannon.

OR you could write a routine to step through all your objects and tell you which
ones have the query in them.