Share this Page URL

Chapter 18. Maintaining an Access Databa... > Viewing Object Dependencies - Pg. 629

Maintaining an Access Database 629 The list includes the tables to which the MarketingCampaigns table is related. As you might expect, this table doesn't depend on any queries, forms, or reports, but as you saw earlier in this procedure, many queries, forms, and reports depend on it. On your own, display object dependency information for other objects in the HelloWorld database. When you've finished, close the task pane. Just the Steps View object dependency information 1. In the Database window, select the object for which you want to view object dependencies. (You can also view object dependencies for an object you have open, provided the object has been saved at least once.) On the View menu, click Object Dependencies. In the task pane, select Objects That Depend On Me or Objects That I Depend On to switch between views of the dependency information. Expand an entry for an object in the list to see the dependency information for that object. 2. 3. 4. Quick Check Q. For which types of objects can you view object dependency information? A. Tables, queries, forms, and reports. Access doesn't generate dependency information for database objects such as data access pages, macros, modules, and so on. Q. What option needs to be enabled to view object dependencies? A. The Track Name AutoCorrect Info option, which is located on the General tab of the Options dialog box.