Access, ask a query what other database objects use it and where

[Guest]

I am astonished that Access is still largely unsearchable.

I desperately want to be able to search the entire database for the name of
a query such that if I rename a query or change it in some way I know what
other queries, modules reports, forms, or macros will be impacted.

Even better still would be able to right click on a database component such
as a query and have the option to ask what other components of this database
use you. That would be perfect.

I really want to be able to see the relationships between the database
objects, the queries, modules reports, forms, or macros.

I regularly fear that changes that I make one part of a large system will
break something in some other part that I had no idea was related.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-82de-2cc6cd17c2c0&dg=microsoft.public.access

 

[Larry Linson]

I am astonished that Access is still largely unsearchable.

Perhaps Microsoft will provide the capability you desire as a result of your
post... of course, only people using the discussions.microsoft.com user
interface can "click and vote".

In the meanwhile, there are third-party software tools that search in design
view for a specific string that you enter, then give you the option of
choosing which, if any, of the occurrences to replace. They are consistently
rated well by users: Speed Ferret by Black Moshannon Systems,
http://www.moshannon.com and Find and Replace by Rick Fisher Software,
http://www.rickworld.com.

Also, you'll find more information than the average developer can use is
provided by Total Access Analyzer, from FMS, Inc., http://www.fmsinc.com.

You may find some free tools that do part or all of what you want...
Googling this newsgroup and comp.databases.ms-access should give you
references. A few personal suggestions would be Google the Internet for
"mztools", and the newsgroups for "free tool", for "Jeff Conrad", for "Arvin
Meyer", and for "Tony Toews".

Microsoft's Name Autocorrect, most believe, causes more problems than it
fixes.

Larry Linson
Microsoft Access MVP