Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals.
Can Total Access Analyzer be used for Unit Testing?
No. Total Access Analyzer only documents your database objects in a static mode. It documents the references between objects and lets you know how they are connected to each other. It also generates hierarchical flow diagrams that can help you understand how your application, objects and data flow: http://www.fmsinc.com/MicrosoftAccess/Documentation/diagrams/index.html
But it does not run your code or objects.
To perform unit testing on VBA Module code, you would need to add procedure calls to the entry and exit of each procedure then log them. We don't have a program that does that. Total Visual CodeTools can add error handling to all your procedures if they lack it. That can provide a rudimentary way to get code at the top and bottom of each procedure, but it's not fail safe as procedures that don't exit at the end of each procedure could circumvent that. For instance, commands like Exit Sub or Exit Function in the middle of the procedure.
If you're only interested in one procedure, you can log the information at the beginning and end of just that procedure to diagnose it. Our consulting services team can assist you with this if you'd like.
Please sign in to leave a comment.