Identifying dependencies

[Dave]

I have an Access file that has over 100 queries, many of which are no longer
being used to support forms or reports.

How can I identify all of the objects that are dependent on (or simply
reference) a particular query?

Likewise, is it possible to identify all of the database objects that a
particular form references (i.e., queries, tables, sub forms, reports, etc.)

The database I am using is in Access 2000 format but I am using Access 2003
and can convert it if necesssary.
Thanks
Dave

 

[Wayne Morgan]

I would normally suggest that you have Name Auto Correct turned off, but it
has to be on to do this. Go to Tools|Options|General tab and check Track
Name AutoCorrect Info, if it isn't already. Next, select the object in the
database window that you want the dependencies for and go to View|Object
Dependencies...

You may also find the Analyzer handy. Go to Tools|Analyze|Documenter.

 

[Larry Daugherty]

HI Dave,

The two tools usually recommended are Find And Replace from
www.rickworld.com and Speed Ferret from http://www.moshannon.com/

They don't make it painless but they make it possible.

FWIW I always start the design of a form or report on the underlying table
and then modify the data source to create a query which I save as part of
the form or report, effectively, basing each form or report on its own SQL
statement. That keeps clutter and multi-client queries out of the query
window and when a form or report is deleted, its SQL goes with it.

HTH

 

[gls858]

I have an Access file that has over 100 queries, many of which are no longer
being used to support forms or reports.

How can I identify all of the objects that are dependent on (or simply
reference) a particular query?

Likewise, is it possible to identify all of the database objects that a
particular form references (i.e., queries, tables, sub forms, reports, etc.)

The database I am using is in Access 2000 format but I am using Access 2003
and can convert it if necesssary.
Thanks
Dave

I'm using Access 2003 also. If you select the object and right
click there is a selection for object dependencies.

gls858

 

[Dave]

Thanks everybody!

That's pretty cool.

It looks like the "unsupported objects" node is anything with a sub-SELECT,
UNION queries and action queries. But at least you have a list of what was
ignored.

Thanks again. All useful, helpful info.