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.
Does Total Access Analyzer support Access Data Projects (ADPs)?
Yes, Access ADPs were introduced in Access 2000 and last supported in Access 2010. Total Access Analyzer for Access 2000 through 2010 supports the documentation and analysis of Access ADPs.
The documentation is for the Access objects in the ADP and what Access can see in SQL Server, but does not include all the backend features of SQL Server.
Because of the many differences between ACCDB/MDB Jet Database format and ADPs, there are significant differences between the documentation generated and the way it behaves. Certain object types are similar between ACCDB/MDBs and ADPs. For instance, forms, reports, macros, VBA modules, command bars, and import/export specifications are essentially the same with similar documentation.
However, some objects only exist in one and not the other. For instance, queries only exist in ACCDB/MDBs, while ADPs have views, database diagrams, and stored procedures. Total Access Analyzer generates the appropriate documentation for all of these objects.
Both ACCDB/MDBs and ADPs have tables, but they are different. ACCDB/MDBs can link to tables or have tables stored within the database itself. ADPs only link to tables that exist on SQL Server. The documentation of the tables is also slightly different. Fields in Access databases are called Columns in ADPs. ADP tables also have Keys and Triggers. Again, these are documented based on the database type.
Please refer to the manual or help file (specifically the sections MDB vs. ADP Documentation and Documentation Limitations for ADPs) for details about documenting ADPs.