AccessObject.IsDependentUpon method (Access)
Returns a Boolean value that indicates whether the specified object is dependent upon the database object specified in the ObjectName argument.
Syntax
expression.IsDependentUpon (ObjectType, ObjectName)
expression A variable that represents an AccessObject object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| ObjectType | Required | AcObjectType | An AcObjectType constant that represents the type of database object to check for dependency. |
| ObjectName | Required | String | The name of the database object to check for dependency. |
Return value
Boolean
Remarks
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. 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", 1You have insufficient permissions to check the dependency information for the specified AccessObject object.
This method is being called from an Access project (.adp).
Access does not search Visual Basic for Applications (VBA) code, macros, or data access pages for dependencies.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.