Link to home
Start Free TrialLog in
Avatar of sk1922
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.

Thanks,
SK1922
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

"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 ?

mx
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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.
Avatar of sk1922
sk1922

ASKER

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.
Then TAA is the tool you need. Lots of report, and more information that you can use!
VSS works with Access 2007 and 2010. Need to install the developer extensions to activate it
Examples of many of the reports, including cross reference reports are here:
http://www.fmsinc.com/MicrosoftAccess/Documentation/Reports/

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.
"Then TAA is the tool you need. "

Humm ...

SK1922, What exactly was your solution ?