How to Display Object Dependencies in Access 2016
Use the Object Dependencies feature to check which objects are used by a table, query, form, or report.
Object Dependencies is a feature of Access that allows you to see which database objects rely on other objects.
This can be helpful for when you're thinking about deleting an object. Before deleting an object from the database, you should first check to see if any other objects are dependent on it. If they are, you should remove the references to the object before deleting.
The Object Dependencies feature can also be useful for planning design changes and future enhancements to the database. Being able to view an object's dependencies can help you understand how each object will be affected by any future design change.
Here's how to display the an object's dependencies.
Limitations of the Object Dependencies Feature
As handy as this tool is, there are some important limitations that you need to be aware of before using it.
- Dependency information is only available for objects that you have permission to open.
- Dependency information is not displayed for:
- Macros and code modules.
- Action queries (i.e. queries that either insert, update, or delete data).
- SQL-specific queries, including union queries, data-definition queries, and pass-through queries
- Subqueries (however, dependency information is still available for the outer query — just not the nested query).
- The Object Dependencies feature requires the name Autocorrect feature to be enabled. If it is disabled, you will be prompted to turn it on before you can view the dependency information.