Identifying Object Dependencies

You can view object dependencies for tables, queries, reports or forms in your database. Deleting objects with dependent objects can cause errors in your database. So, before deleting an object, it is a good idea to check to see if any objects are dependent on it. If there are dependent objects, you should either delete those objects or remove the dependencies from the object you want to delete.

To view the object dependencies in your database:

1. Select the object you want to view dependencies for.
2. Click the View menu and select Object Dependencies. The Object Dependencies Task Pane opens.
3. To view the objects that depend on the selected object, make sure the Objects that depend on me radio button is selected.
4. Click the expand icon (+) to see the related objects.
5. To view the objects used by the selected object, click the Objects that I depend on radio button.
6. Click the expand icon (+) to see the objects used by the selected object.

• Click the collapse icon (-) to close an expanded list.
• Hidden object are not displayed in the list of object dependencies.

You cannot view object dependencies for data access pages, macros or modules. In addition, objects which are not supported by the name AutoCorrect feature are not supported, including subqueries, action queries and SQL-specific queries.

If the task pane is already displayed, you can click the Other Task Panes arrow at the top of the task pane and select Object Dependencies to view object dependencies.