Avatar of sk1922
 asked on

Access 2007 - Object Analyzers (Suggestions/Recommendations/Pitfalls)

Hello EE!

Seeking some recommendation on best approach for analyzing object references within MS Access applications.  We have a team building an application using Access front-end and they're battling extensive challenges during the test phase.  I believe we can remedy this through a tool that would report back, identifying all related objects within the heirarchy of the modified object.  The focus is on the front-end of the application as the back-end leverages SQL Server resulting in easier testing / validation for DB objects.

I know there's a product called Total Access Analyzer which is an Access add-on but our team isn't finding it very useful.  Wondering if anyone here has had experiences with tools similiar to this one and can share their experience.

Microsoft AccessMicrosoft Office

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"I know there's a product called Total Access Analyzer which is an Access add-on but our team isn't finding it very useful"
Humm ... I'm quite familiar with TAA ... and I find the amount of info returned about a given database is nothing short of amazing.

What is it not doing for you ?

Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Luke Chung

Whether it's one developer or multiple developers, we use Microsoft Visual SourceSafe to handle version control and check in/check out of objects.

Total Access Analyzer offers detailed cross reference, hierarchical diagrams, code analysis, and lots of recommendations to fix errors, design, and performance issues. It offers the control enterprises require for their platforms.
Scott McDaniel (EE MVE )

Does VSS work with the new versions of Access? I used it for a time with 2003 but haven't tried it with newer versions.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck

Thanks for the response Experts.  

My team is looking to generate a report that returns back the object cross references across the application.  To compare code, we use a totally different tool so no issue there.  Mainly we need to understand what code changes are impacting what part of the application - it is our impression TAA can help in this area.  However, according to my team, the information is very difficult to read/understand to make any decisions. Guessing it returns too much information or "metadata" of sorts.   We are using TFS for our source control.
Scott McDaniel (EE MVE )

Then TAA is the tool you need. Lots of report, and more information that you can use!
Luke Chung

VSS works with Access 2007 and 2010. Need to install the developer extensions to activate it
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Luke Chung

Examples of many of the reports, including cross reference reports are here:

The reports can be previewed, printed or sent to report view for ad hoc filtering. The data is also available on forms that can be searched and filtered. Hope this helps.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"Then TAA is the tool you need. "

Humm ...

SK1922, What exactly was your solution ?