Is there an easy way to do a cross-reference of data sources used?

SQLWayne

Registered User.
Local time
Today, 09:55
Joined
Nov 23, 2015
Messages
21
What I need is a list of all my tables, and then all of the queries/forms/reports dependent on them. I can do it manually, but I'd be more confident that I'm catching all of them if I can access the metadata and report directly and print it, and I have a feeling that's not possible.

At least I'm running Access 2010 and can run the Object Dependencies tool: 2013 can't run dependencies against attached tables, which is just silly. The dependency tool does what I need, but you can't print it, and copy/paste to Paint is just silly. And it's probably what I'll have to do.

Maybe there's a third party tool that's available cheap that can do it?
 
Thank you, that might do the trick. At least it's some code that I can use as an example.
 

Users who are viewing this thread

Back
Top Bottom