Identifying Object Dependencies

graphics/microsoft81_1.gif

As you develop a database, you create a relationship between objects to share data and provide the information in forms and reports . When you make changes to one object, it might affect another object. For example, if you no longer need a field in a table, instead of deleting it right away and possibly creating problems, you can check object dependencies to make sure that the field you want to delete is not used in another table. Checking for object dependencies helps you save time and avoid mistakes. Access generates dependency information by searching name maps maintained by the Name AutoCorrect feature. If Track Name AutoCorrect Info is turned off on the General tab in the Options dialog box, you cannot view dependency information.

View Dependency Information

graphics/1_icon.jpg

In the Database window, click the object in which you want to view dependencies.

graphics/2_icon.jpg

Click the View menu, and then click Object Dependencies.

graphics/3_icon.jpg Click the Objects That Depend On Me option or the Objects That I Depend On option.

The Object Dependencies task pane shows the list of objects that use the selected object.

graphics/4_icon.jpg

To view dependency information for an object listed in the pane, click on the Expand icon (+) next to it.

graphics/5_icon.jpg

When you're done, click the Close button on the task pane.

graphics/03inf15.jpg

Did You Know?

You can view a list of database objects . Click the File menu, click Database Properties, and then click the Contents tab. When you're done, click OK.


Dependency Information

Object

Dependent

Description

Table

Table or query

A relationship is defined between the objects

Table

Form

Fields in the selected table look up values

Query

Table or query

Query is bound to the table or query

Form

Table or query

Form is bound to the table or query

Form

Form

Form includes the other form as a subform

Report

Table or query

Report is bound to the table or query

Report

Form

Report includes the form as a subform

Report

Report

Report include the other report as a subreport




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net