Microsoft added a wonderful feature to Access 2003. It provides the capability to view information about object dependencies. Here's how it works:
To invoke the Object Dependency feature, right-click the object whose dependencies you wish to view, and select Object Dependencies. The first time that you perform this task for a database, a dialog box appears prompting you to update object dependency information for the database (see Figure 29.17). 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 29.18).
Figure 29.17. The first time you attempt to display object dependencies within a database, Access prompts you to update dependency information for that database.
Figure 29.18. The Object Dependencies window shows you the objects that depend on the selected object, as well as objects that the selected object depends on.
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.
Click the node of an item to drill down to additional dependencies. For example, in Figure 29.19 I have clicked to expand the qryClientListing and qryClients nodes. The qryClientListing query depends on the tblClients table (the table whose dependencies we are viewing). The report called rptClientListing depends on the qryClientListing query, which ultimately depends on the tblClients table. The qryClients query depends on the tblClients table. The frmClients form uses the qryClients query. The qryPayments and qryProjects queries and the frmPayments, frmProjects, and fsubClients forms all depend on the frmClients form. Using the Object Dependencies window, you can drill even further down the chain to the objects that depend on those objects.
Figure 29.19. You can drill down to see the chain of dependencies for an object.
Close the Object Dependencies window when you are finished viewing and working with object dependencies.
لطفا منتظر باشید ...
