Access object inventory system that can find derelict objects?

[cedar]

Does anyone know of an Access object inventory system that can find unused objects? I think FMS has one. I wrote one, or part of one, in the 90s but lost track of it. I have a plain jane object inventory system, but all it does is mine objects. What missing is relationships, and any of the very useful stuff like "this query is consumed by this and that form, and itself consumes these other two queries.

I have been minding a database that originated in the 90s now for quite a while. Over time it has changed radically. It has a massive amount of code and objects that are derelict. I tend to clean up my disused stuff, but the previous developer didn't at all. It'd be really tough to try to sort it out manually.

 

[cedar]

After posting I realized I might have run into something like what is needed, and found it again

access dependency checker

(I guess I can't post an actual url?)

I'm testing it now, will report back on how it does.

 

[isladogs]

With a bit of work, the built in Object Dependencies tool will do what you want but it doesn't work with macros, modules or subqueries
The free AccessDependencyChecker handles all object types and works well.

As for commercial tools, these will also find unused objects but also do additional things that you may or may not need
These include Total Access Analyzer from FMS and my own Database Analyser Pro app

 

[DHookom]

After posting I realized I might have run into something like what is needed, and found it again

access dependency checker

(I guess I can't post an actual url?)

I'm testing it now, will report back on how it does.

You can’t post URLs until you have posted 100 times. This includes replying to a post that includes an URL. I used a lot of posts welcoming new members to get up to 100.

 

[cedar]

Duane you just cracked me up, thanks!

 

[tvanstiphout]

You can’t post URLs until you have posted 100 times. This includes replying to a post that includes an URL. I used a lot of posts welcoming new members to get up to 100.

For years I was jealous of Duane to know so many friends...

 

[Pat Hartman]

The dependency checker is very useful for immediate use if you want to check on a specific object because you want to change that object and assess the impact before you start.

I haven't used Colins tool so don't take that as meaning I don't like it. However, I have used the FMS tool and found it to be very useful. I stopped taking new clients almost 10 years ago so I haven't used TAA in quite a while but it is a lifesaver when you have to get up to speed with an unfamiliar application. Since I always work for myself I buy my own tools but if you are an employee, your employer should not object to purchasing any of the FMS or Colin's tools since they would save you potentially hours of time and aggravation. Just calculate the cost of your time, including overhead and it is easy to justify a tool that costs $500 (I think most of the FMS tools are less than that) to did into an unfamiliar application that has no documentation.