Solved

MS Access - Finding Queries Not Used In Macros

Posted on 2012-03-22
6
267 Views
Last Modified: 2012-03-22
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?
0
Comment
Question by:keschuster
  • 3
  • 2
6 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 37752666
You might want to take a look at Total Access Analyzer
0
 
LVL 57
ID: 37752790
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
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37752801
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 57
ID: 37752832
<<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
 

Author Comment

by:keschuster
ID: 37752899
sweet
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37752901
Thanks, Jim!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now