Where used?

S

Stephanie

My bad. I'm trying to clean up my db, deleting old queries. I'm wondering
if there is a way to find out if a given query is being used by any other db
objects (forms, reports) without 1) poking around 2) deleting and being sorry.

Thanks!
 
R

RuralGuy

To begin with...don't delete, rename. I rename them starting with an
_UnderScore so they will sort at the end. If it causes a problem it is still
there to rename back to the original name. Having said that, here's another
possible solution: http://allenbrowne.com/ser-41.html


My bad. I'm trying to clean up my db, deleting old queries. I'm wondering
if there is a way to find out if a given query is being used by any other db
objects (forms, reports) without 1) poking around 2) deleting and being sorry.

Thanks!
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
S

Stephanie

Thanks for the tips!

RuralGuy said:
To begin with...don't delete, rename. I rename them starting with an
_UnderScore so they will sort at the end. If it causes a problem it is still
there to rename back to the original name. Having said that, here's another
possible solution: http://allenbrowne.com/ser-41.html




_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 
W

Wayne Morgan

If using Access 2003, try right clicking the query in the database window
and choose Object Dependencies....
 
R

RuralGuy

Wayne,
I think that only works if you have "Name Auto-Correct" turned on. It has so
many problems that most MVP's strongly recommend it be turned off.
Failures caused by Name Auto-Correct
http://allenbrowne.com/bug-03.html


If using Access 2003, try right clicking the query in the database window
and choose Object Dependencies....
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
W

Wayne Morgan

You're correct and I agree, but it is there. It would be best to use a copy
of the file, turn name autocorrect on for the copy, and check the
dependencies then turn name autocorrect back off again.
 
Top