|
Free Resources from FMS |
|
|
|
|
"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - Darren D. |
|
|
|
|
Microsoft
Access Resource Center
Object Dependencies
Provided by: Steve Clark, Senior Project Manager
In Microsoft Office Access 2003, a new feature has been added to help you determine which objects require another object, or whether the object is needed for another object. This is what is known as a dependency. For example a report is dependent on a query for it's data, or a Main form may have a subform dependent.To see an example of this new feature try the following:
-
Open the Northwind Database
-
Click on the Forms tab,
-
Click one time on the "Customer Orders" form to highlight it.
-
From the Main Menu, choose View, Object Dependencies...
This action will open a task pane titled 'Object dependencies', and gives you two options:
-
Objects that depend on me
-
Objects that I depend on
But there are several lesser-known shortcuts that can cut down on your typing and keep you working mouse-free. The lists below include some of the shortcuts that I find most useful, but Access offers many more shortcuts for you to take advantage of. For a list, refer to the “Keyboard Shortcuts” topic (online or in the Microsoft Access help file).
A treeview of different categories for the object allows you to navigate easily to see the dependencies. For 2003, the categories are Tables, Queries, Forms, and Reports. This can visually give you a better idea of how any object is used throughout a database. There is nothing worse than deleting an needed object that you thought was no longer used.
Note: Access 2003 generates the dependency information by searching the name maps. These maps are maintained by the Name AutoCorrect feature. If tracking name AutoCorrect information is turned off, you cannot view dependency information. This setting is found on the General Tab of the Tools/Options menu choice.
