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?
keschusterAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
You might want to take a look at Total Access Analyzer
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Better yet,

Find and replace:

www.rickworld.com

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.

Jim.
0
 
Dale FyeCommented:
Jim,

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.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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
Jim.
0
 
keschusterAuthor Commented:
sweet
0
 
Dale FyeCommented:
Thanks, Jim!
0
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.