Object dependancies

[PatrickJohnson]

Is there a way I can print something that will tell what each table and/or query is dependent on and what depends on each one? I don't mean relationships, just the dependencies. I'm trying to clean up a database but it was built before I started and I use some of the prebuilt stuff and don't want to delete anything I need, but the query and table lists are excrutiatingly long.

 

[llkhoutx]

There's nothing in Access that does that.

SpeedFerret and FMS have tools which may be of help to you.

 

[PatrickJohnson]

hmm, what a stupid thing for Microsoft to leave out. I can't imagine that they wouldn't think this would be useful.

 

[llkhoutx]

I agree with your comment.

 

[Cosmos75]

How about Questica?
- Download
- Support Forum (No recent activity)

After installing it, two options should appear on your right-click menu when you right-click a table or query:
- Dependencies
- References

Hope this helps!