Identifying Object Dependencies

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 General tab in the Options dialog box, you cannot view dependency information.

View Dependency Information

In the Database window, click the object in which you want to view dependencies.

Click the View menu, and then click Object Dependencies.

Click the Objects That Depend On Me option or the Objects That I Depend On option.

The Dependency pane shows the list of objects that use the selected object.

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

To open an object in Design view, click the object on the task pane.

When you're done, click the Close button on the task pane.

Did You Know?

You can view a list of database objects . Click the File menu, click Database Properties, and then click the Contents tab. When you're done, click OK.