Find Unused Forms, Queries, Reports, etc

[Guest]

I inhereted a database from the previous IT guy. <sigh> I am pouring over this 100+ form, report, query database and I am starting to go more insane than I am right now.

Is there a way to see if there are forms, reports, or queries, that are currently unsed in a databse? I would like to trim the FAT off this monster, but I am afraid to remove anything to avoid a crash. Also, the database was not split so the data is here as well.

I am in the process of splitting this thing right now.

Thanks as Always,
RIP

 

[Albert D. Kallal]

In access 2003, you can right click any query, or form or whatever, and it
will show you object dependences.

However, it certainly can not, and does not work for code.

I mean, in code you can go:

strForm = inputbox("What form to open")

docmd.OpenFrom strFrom

So, dependences in code can't be resolved at all. If there is a lot of code
in your application, then knowing that you have a query that is NOT used by
a form, and is NOT used by report still does not mean you can get rid of the
query..since code might use that query.

There are thus some tools that can help you.

For example, if you are in some code, and need to know what OTHER code
routines call the current code you are in, then check out:

http://www.mztools.com/

The above is a AMAZING free tool that has all kinds source code editing and
aids to help you.

There are also some commercial products that do help with some of the
dependences searching, but often as showen above, you can resolve
dependancies untill the code is run...
.....