What is using a Query

[AC5FF]

I'm trying to clean up a database as well as have to modify it a bit. For the record; this DB was created YEARS ago by another guy no longer with the company.

This DB has a TON of queries that I cannot tell if they are being used or not any longer. Is there any way to determine what - if anything - is using a query? I.E. reports/other queries/etc. and if the list is blank I will know it is safe to delete?

I could just rename things and wait until one of my techs tries to do something that no longer works correctly, but I don't think that's the way to do this.

Ideas?

 

[speakers_86]

Don't waste your time. Having unused queries wont hurt anything. If you do go and change a bunch of stuff, make sure perform name autocorrect is off.

 

[Galaxiom]

Download V-tools and use the Deep Search function to find any instance of a term anywhere in the project.

 

[spikepl]

Tab: Database Tools->Object dependencies

 

[Galaxiom]

Tab: Database Tools->Object dependencies

This does not show the use of an object in the code or an SQL RecordSource or RowSource. It can't report on union queries.
It is often wrong about the rest too but tends to over report usage.

BTW, when using V-tools you may need to Compact and Repair after deleting an object.

 

[jdraw]

Galaxiom,

Do you have a set of instructions for using VTools? IIRC, I had to modify some field and object names in a database I was helping a poster with - I downloaded vtools, but was surprised by the lack of operational info. I think spikepl or plog helped me get it going. That was the only time I used it. It did make the handful of changes needed, but seemed to lack instructions. Then again, maybe I'm just old -- in any event - if you or others have such material, I'm sure it would be appreciated by many.
Thanks in advance.

 

[Galaxiom]

Do you have a set of instructions for using VTools?

The problem most have is finding it. It is an Add-In. Once installed its functions are under Database Tools ribbon > Add-ins.

I have only used the Total Deep Search. Its configuration seems self explanatory.

 

[speakers_86]

Here

 

[HiTechCoach]

Tab: Database Tools->Object dependencies

Note: This only work if it has not turned it off for the database. A lot of developers turn this off.

 

[HiTechCoach]

This DB has a TON of queries that I cannot tell if they are being used or not any longer. Is there any way to determine what - if anything - is using a query? I.E. reports/other queries/etc. and if the list is blank I will know it is safe to delete?

NEVER Delete!

Just because it is not being used does not mean that it is not useful. It could be that no one know how to use them.

I could just rename things and wait until one of my techs tries to do something that no longer works correctly, but I don't think that's the way to do this.

Ideas?

Is the database split? If not that should be top priority.


If this were my project I would:

1) create a new dev folder
2) copy the current production front end and back end into this new dev folder
3) relink the copy of the current ront end to the copy of the back end in the new dev folder.
4) create a new blank new front end in the dev folder.
5) start importing a few objects at a time from the copy of the current front end in the dev folder to your new blank front end.
---- start with the tables and the main menu/switch board.
---- starting running and testing the application. As you com across missing objects then you would import them.

This has many benefits. You will also learn a lot about the supplication. Learning the application at this level is critical before you start making any changes. Most people do not have lot of experience modifying other peoples work so this should not be skipped.

This will also give you a good development environment that will also protect you production application and data.


If you have the money, FMS's Total Access Analyzer is great. See: http://www.fmsinc.com/MicrosoftAccess/BestPractices.html