List queries,reports and tables that have no dependencies

[bjreb]

I have a database that is old, I use it for a lot of different things including running quick reports and queries that just get lost in the shuffle. I would like to clean the old stuff out but dread having to go through every single one.
Is there a way in VBA to scan the objects to see if they have dependencies?
If so could I please have the code.

Thanks
Andy

 

[RuralGuy]

What version of Access are you using? ac2013 has an Object Dependencies in the Database Tools.

 

[eshai]

I have a database that is old, I use it for a lot of different things including running quick reports and queries that just get lost in the shuffle. I would like to clean the old stuff out but dread having to go through every single one.
Is there a way in VBA to scan the objects to see if they have dependencies?
If so could I please have the code.

Thanks
Andy

Dim dioGetDependencyInfo As DependencyInfo
   Set dioGetDependencyInfo = aob.GetDependencyInfo