Home > Articles

  • Print
  • + Share This
This chapter is from the book

Identifying Object Dependencies

AC07S-6.2.4.1

As you develop a database, you create a relationship between objects to share data and provide the information in forms and reports. When you make changes to one object, it might affect another object. For example, if you no longer need a field in a table, instead of deleting it right away and possibly creating problems, you can check object dependencies to make sure that the field you want to delete is not used in another table. Checking for object dependencies helps you save time and avoid mistakes. Access generates dependency information by searching name maps maintained by the Name AutoCorrect feature. If Track Name AutoCorrect Info is turned off on the Current Database pane in the Options dialog box, you cannot view dependency information.

View Dependency Information

yellow_circle_1.gif In the Navigation pane, click the database object in which you want to view dependencies.

yellow_circle_2.gif Click the Database Tools tab.

yellow_circle_3.gif Click the Object Dependencies button.

yellow_circle_4.gif Click the Objects that depend on me or Objects that I depend on option.

The Object Dependencies task pane shows the list of objects that use the selected object.

yellow_circle_5.gif To view dependency information for an object listed in the pane, click the Expand icon (+) next to it.

yellow_circle_6.gif When you’re done, click the Close button on the task pane.

Dependency Information

Object

Dependent

Description

Table

Table or query

A relationship is defined between the objects

Table

Form

Fields in the selected table look up values

Query

Table or query

Query is bound to the table or query

Form

Table or query

Form is bound to the table or query

Form

Form

Form includes the other form as a subform

Report

Table or query

Report is bound to the table or query

Report

Form

Report includes the form as a subform

Report

Report

Report include the other report as a subreport

  • + Share This
  • 🔖 Save To Your Account