Microsoft Office Tutorials and References
In Depth Information
Analyzing and Documenting Your Database
Viewing object dependencies
Access can show you a list of the tables, queries, forms, and reports that
depend on an object. Suppose that your database contains a query that you
never use, but you’re not sure you can delete the query, because it may very
well be the record source for a form or report. Access can ease your worried
mind on this subject.
To display a list of object dependencies, select an object in the Navigation
Pane, and click the Object Dependencies button in the Relationships group
on the Database Tools tab of the Ribbon. You may see several message
boxes, saying that dependency information needs to be updated and that
various steps may take a few minutes; click OK in each message box. In the
end, the Object Dependencies pane appears on the right side of the Access
window, as shown in Figure 1-4.
Book VII
Chapter 1
Figure 1-4:
What tables,
queries,
forms, and
reports
depend on
this query?
At the top of the Object Dependencies pane is the name of the object
that you’re analyzing. In Figure 1-4, the object in question is the Orders
By Customer Qry query. (The object has to be a table, query, form, or
report; Access can’t show the dependencies of macros or Visual Basic for
Applications [VBA] modules.) Two options follow the object’s name:
Objects That Depend on Me: Choosing this option lists the tables, queries,
forms, and reports that use this object as a data source. The objects that
depend on a table include the queries based on the table and the forms
and reports that use the table as a record source. The objects that
depend on a form include forms of which this one is a subform.
Search JabSto ::




Custom Search