Lesson 11.10. Displaying Database Object Dependencies
Figure 11-19. Right-click any Access database object and select Object Dependencies
Databases can often be complicated and interconnected. For example, a form might be based on a query, which in turn is based on a table. Deleting the query and your form won't work. So how do you keep track of all these interconnected database objects?
One of the most significant new features in Microsoft Access 2003 is its ability to view object . So, before you delete or rename a query, you can view every database objectevery query, form, and reportthat is dependent on that query. You can also do the reverse and view every database object that the query requires in order to function.
Here's how to view object .