Find Object Dependencies

As a database grows it can be difficult to keep track of object dependencies. For example, several forms could be relying on one query, or a subform could be associated with more than one form. After a while, a developer can become wary of changing or deleting objects, even if he or she is the only developer associated with that database. Things can be even worse if you inherit an application. Talk about proceeding with trepidation. You can now shelve those fears; Viewing Object Dependencies has come to the rescue.

Viewing object dependencies allows you to view what the object depends on as well as what objects depend on it. For example, by selecting a query, you could see what forms and reports are using it and you could also see if it was relying on a form or other queries. The tree view will show tables, queries, forms, and reports that are in the database. However, it will not show macros, VBA code, Data pages, SQL-specific queries, and Access projects. Figure 3-1 shows how to select a table to view the objects that depend on it. By selecting the other option, it will list the objects that it depends on. So, with a couple of clicks, you can look at both types of object dependencies.

The Object Dependencies feature only applies to MDB files.


Figure 3-1


Figure 3-1

The Object Dependencies feature employs the functionality of tree view. As shown in Figure 3-1, you can drill into the dependencies. Actually, this feature will allow navigating up to four levels. However, since the information is based on the name maps maintained by the Name AutoCorrect feature, the tracking function of Name AutoCorrect must be turned on; please note that this does not require Name AutoCorrect to be enabled, but merely turned on. Another nice thing is that if Name AutoCorrect was not turned on before requesting to see the dependencies, a dialog box will prompt you to turn it on. Then, if you choose to turn it on, Access will proceed to display the requested dependency information.

In order for Object Dependencies to be viewed, the Name AutoCorrect feature needs to be turned on. However, it does not have to be enabled.

To view Object Dependencies, from the View menu item select Object Dependencies. At that point, if Name AutoCorrect was not turned on, there will be a prompt to turn it on so as to view the dependencies. To view Hidden Objects, the Show-Hidden Objects will need to be selected on the View tab of the Options dialog box (under Tools | Options).

A word of caution here: Don't rely solely on the dependency lists when deciding to delete database objects. There are several objects that will not show up on the dependency view. Access Help "About Object Dependencies" provides detailed information about which dependencies are shown as well as what types of objects are not included.

0 -1


  • berylla bracegirdle
    How to check dependencies functions in vba?
    7 years ago
  • Jackeline Grant
    How do you display the object dependencies for a selected table on access?
    7 years ago

Post a comment