View information on object dependencies
In Microsoft Office Access 2003, you can view information on dependencies between database objects. Viewing a list of objects that use a specific object helps maintain a database over time and avoid errors related to missing record sources. For example, the Quarterly Orders query in the Sales database is no longer needed, but before deleting it, you might want to find out which other objects in the database use the query. Then, you could either change the record source of the dependent objects, or delete them, before deleting the Quarterly Orders query. Viewing a complete list of dependent objects helps you save time and minimize errors.
In addition to viewing the list of objects that are bound to a selected object, you can also view the objects that are being used by the selected object.
Macros, modules, and data access pages are not searched for dependencies. Access projects do not support this feature.