Deleting old queries

[dmclone]

I have this massive Access database at work and I'm trying to clean it up. Currently we have over 500 queries built. The problem is that soem of these may still be being used and shouldn't be deleted. Is there a way to tell when a query was last used (not modified)?

 

[dcx693]

Not that I know of.

You can make yourself a back up copy of the entire database. Then create a new blank database, back up all the queries to that blank db. Then start deleting the queries from your db. You'll know soon enough which ones are required.

 

[pbaldy]

I don't know a way either. I use a program called Speed Ferret to find out what queries/forms/reports may use each query, then delete it if there are none. If I'm not sure, I'll rename the query but leave it in the db a while, and see if anything breaks (crude but effective). If it turns out it was needed, I just rename it back again. Generally the first solution is all I need.

 

[Thecherub]

You can check some through reports

You can check some of whats needed with the show Feilds buttom on the reports screen it also shows you the name of the querry of table involved.

I hope that helps a bit at least.