Share this Page URL

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

Maintaining an Access Database 625 Figure 18-2. The General tab of the Options dialog box. Keep the Track Name AutoCorrect Info option selected to view object dependencies When Access is set up to track name changes, Access stores a name map for each object and updates the map if the object's name is changed. If you set up Access to perform automatic name correction in addition to tracking changes to object names, Access updates references to an object when you rename it. For example, if you rename a query that's used as a record source for a form, Access updates the Record Source property of the form with the query's new name. Access uses the name maps it creates through the Name AutoCorrect feature to maintain information about object dependencies. If the Track Name AutoCorrect Info option has been cleared, Access will display a message box when you click View, Object Dependencies, indicating that the option must be enabled before Ac- cess can generate dependency information. You can enable the option by clicking OK in the mes- sage box. The time that Access then takes to generate information about object dependencies will vary on the basis of the number of objects in the database. Access can display information about object dependencies for a database object you have open or for an object you've selected in the Database window. (An object must have been saved at least once for Access to generate dependency information for that object.) Users who don't have per- mission to open a database object in Design view can't view dependencies for that object. In the following steps, we'll view object dependencies for two of the tables in the HelloWorld data- base. View object dependencies 1. 2. If the HelloWorld18 database isn't open, open the file HelloWorld18.mdb, located in the Chap18 folder. In the Database window, right-click the MarketingCampaigns table, and then click Object De- pendencies.