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.