• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. What Every Developer Needs to... > Viewing Object Dependencies

Viewing Object Dependencies

Microsoft added a wonderful feature to Access 2003 called Object Dependencies that provides the capability to view information about object dependencies. Here's how it works:

1.
To invoke the Object Dependencies feature, right-click the table whose dependencies you wish to view, and select Object Dependencies. The first time you perform this task for a database, a dialog appears prompting you to update object dependency information for the database (see Figure 2.45). After you click OK, Access updates the dependency information for the database and displays the Object Dependencies window on the right-hand side of the Access desktop (see Figure 2.46).

Figure 2.45. The first time you attempt to display object dependencies within a database, Access prompts you to update dependency information for that database.


Figure 2.46. The Object Dependencies window shows you the objects that depend on the selected object as well as objects that the selected object depends on.


2.
By default, the Object Dependencies window shows you the objects that depend on the selected object. You can click the Objects That I Depend On button to view the objects that the selected object depends on.

3.
You can click the node of an item to drill down to additional dependencies. Because we have not established relationships between the tables, and this database contains no queries, forms, or reports that are based on the tables in the database, no dependencies yet exist. If you practice this exercise on the Northwind database, you will find the results to be much more interesting.

4.
Close the Object Dependencies window when you are finished viewing and working with object dependencies.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint