Access™ 2007 VBA Programmer's Reference

G.5. AccessObject

The AccessObject object refers to a particular object within any of the following collections: AllDatabaseDiagrams, AllForms, AllFunctions, AllMacros, AllModules, AllQueries, AllReports, AllStoredProcedures, AllTables, and AllViews. This is an all-purpose object that can be used to determine whether an object is dependent upon another object or whether an object is open in the database.

It has its own properties, described in the following table, that you can implement within your code.

Property	Data Type	Description
CurrentView	AcCurrentView Enum	Returns the current view for the specified Access object.
DateCreated	Date	Returns the date the AccessObject was created.
DateModified	Date	Returns the date the AccessObject was modified.
FullName	String	Sets or returns the full path of the object.
IsLoaded	Boolean	Determines whether the object is currently loaded.
Name	String	Returns the name of the object.
Parent	Object	Returns the collection of which the object is a member.
Properties	AccessObjectProperties collection	Returns the AccessObjectProperties collection for the object.
Type	AcObjectType Enum	Returns the type of the AccessObject.

AccessObject has two methods you can use:

Method	Arguments	Description
GetDependencyInfo	None	Returns a DependencyInfo object that represents the database objects that are dependent upon the specified object.
IsDependentUpon	ObjectType, ObjectName	Returns a Boolean value that indicates whether the specified object is dependent upon the database object specified in ...