Where used?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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...
 
If using Access 2003, try right clicking the query in the database window
and choose Object Dependencies....
 
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.
 
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.
 
Back
Top