Isn't there a dependency view in Access 2010?
Sent from my Kindle Fire
From: "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Tue May 05 14:28:47 PDT 2015
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Re: Total Access Analyzer
Nevermind – found this. I might just create a handy dandy form to call these cool procedures?
http://stackoverflow.com/questions/7831071/how-to-find-all-queries-related-to-table-in-ms-access
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, May 05, 2015 2:09 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: Total Access Analyzer
Bill et al.,
Which tool to you recommend to quickly view the tables used for the queries?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, May 05, 2015 9:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Total Access Analyzer
I've used FMS Total Access Analyzer for years, Liz. It's not perfect in pointing out unused code. It can't spot functions that are only used in queries. And you can filter out some of the other "errors". FMS assumes a high standard where it might not be necessary.
But over all, it's a good tool especially when you are taking over the development/support of someone else's work. The other 2 tools I can't live without are MZTools and SmartIndent (links in our More>Links>Development Tools)
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Crystal, your documenter is wonderful!
Pros, we got an additional documenter in addition to Crystals called Total Access Analyzer because that was supposed to show unused modules and database errors.
So I've just started looking at the error list, and see things like 2 or more tables are linked - ? and dlookup is used ?
Anyone play with this software before?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Bill Mosca <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar