MS Access - Finding Queries Not Used In Macros

I have an old database that has grown a beard and walks with a cane...  I have queries and probably tables that are not used and are just taking up space.   My DB runs from macros so I'm trying to find a way that will list out all the macros' actions.  With that I can try to figure out which objects are not being used.  Is there another way to do this other than the build in documenter (it sucks..)

Another thing that would help is a list of all queries that have no dependencies... Looking in the Object Dependencies it doesn't show Macro dependencies... Not much help for me.

Any ideas?
Who is Participating?
Dale FyeConnect With a Mentor Commented:
You might want to take a look at Total Access Analyzer
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Better yet,

Find and replace:

There is a cross reference utility in there that will do exaclt y what you want, and it's a heck of a lot cheaper.

Dale FyeCommented:

Good info.  I have used Total Access Analyzer in the past (convinced a previous employer that is was a necessity), but did not realize the F&R 9.0 (which I own personally) has a cross-reference functionality.  

I'll have to check that out tonight.
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<but did not realize the F&R 9.0 (which I own personally) has a cross-reference functionality>>

 Everyone misses it...

Screen shot
and then you get

screen shot 2
keschusterAuthor Commented:
Dale FyeCommented:
Thanks, Jim!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.