List queries,reports and tables that have no dependencies

bjreb

Registered User.
Local time
Today, 20:46
Joined
May 7, 2001
Messages
37
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
 
What version of Access are you using? ac2013 has an Object Dependencies in the Database Tools.
 
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

Code:
Dim dioGetDependencyInfo As DependencyInfo
   Set dioGetDependencyInfo = aob.GetDependencyInfo
 

Users who are viewing this thread

Back
Top Bottom