Show All

GetDependencyInfo Method

Returns a DependencyInfo object that represents the database objects that are dependent upon the specified object.

expression.GetDependencyInfo()

expression    Required. An expression that returns an AccessObject object.

Remarks

Access does not search Visual Basic for Applications (VBA) code, macros, or data access pages for dependencies.

This method will return a run-time error if any of the following conditions are true:

• The Track name AutoCorrect info setting (Tools menu, Options dialog box, General tab) is disabled. You can use the following code to enable the Track name AutoCorrect info setting and update the dependency information for all of the objects in the database:

  Application.SetOption "Track Name AutoCorrect Info", 1

• You have insufficient permissions to check the dependency information for the specified AccessObject object.
• This method is being called from an Access project (.adp).