How to print all "Dependancies" at once ??

[Will]

Is there a way to have Access print a listing showing how all tables,
queries and Forms depend on each other?

I tried the the Tools | Analyze | Documenter but that didn't seem to give me
that option.

Right now all I can do is select each object then right click it and ask for
dependancies... very labor intensive when you have a bunch of objects.

thanks for any help.

 

[Guest]

Hi Will,

If it's possibly within your budget, the tool that you need is Total Access
Analyzer by FMS: http://www.fmsinc.com/products/analyzer/index.html

I have version 10.5 for Access 2002. This tool is worth every penny of it's
cost in my opinion.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Is there a way to have Access print a listing showing how all tables,
queries and Forms depend on each other?

I tried the the Tools | Analyze | Documenter but that didn't seem to give me
that option.

Right now all I can do is select each object then right click it and ask for
dependancies... very labor intensive when you have a bunch of objects.

thanks for any help.

 

[Danny J. Lesandrini]

Check out the Questica Query Dependency tool.

Link to page.
http://www.download.com/3000-2383-10212365.html


Link to download ... watch word wrap on URL
http://dw.com.com/redir?pid=1021236...83&siteId=4&edId=3&pid=10212365&psid=10212364

 

[Will]

OK, I downloaded and ran setup... but where is the Add In file?

It didn't show up in my Add In folder on XP Pro.

thanks,

Will

 

[Dirk Goldgar]

OK, I downloaded and ran setup... but where is the Add In file?

It didn't show up in my Add In folder on XP Pro.

Just right-click on a query or table in the database window and see the
new "Dependencies" and "References" options that appear on the popup
menu.

 

[Guest]

Hi Danny,

It's been a while since I used the Questica Query Dependency tool. Do you
know if this will help with Will's request for form dependencies?

Thanks for providing an updated link. I first learned about this tool by
reading your review in the Sept., 2003 issue of Smart Access. However, the
link shown in that issue
(http://www.questica.com/services/QueryDependencies.asp) is no longer valid.
I attempted to contact Questica on this issue but, of course, I heard nothing
back from them.

Tom
_______________________________________

:

Check out the Questica Query Dependency tool.

Link to page.
http://www.download.com/3000-2383-10212365.html


Link to download ... watch word wrap on UR
http://dw.com.com/redir?pid=1021236...83&siteId=4&edId=3&pid=10212365&psid=10212364

 

[Danny J. Lesandrini]

Well, I wasn't sure if it would meet his needs, but I thought it
would be worth it for him to look at it. Sometimes you don't
know what you need until you see it