Access object inventory system that can find derelict objects? (3 Viewers)

[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.