Does Total Access Analyzer support Access Data Projects (ADPs)?

0
Posted

Does Total Access Analyzer support Access Data Projects (ADPs)?

0

Yes. Total Access Analyzer (version 2000 and later) supports documentation and analysis of Access ADPs. The documentation is for the Access objects on the ADP and what it can see in SQL Server, but not all the backend features of SQL Server. Because of the many differences between MDB (includes ACCDBs) and ADPs, there are significant differences with the documentation Total Access Analyzer generates and the way it behaves. Certain object types are similar between MDBs and ADPs. For instance, forms, reports, data access pages, macros, 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 MDBs, while ADPs have views, database diagrams, and stored procedures. Total Access Analyzer generates the appropriate documentation for all of these objects. Both MDBs and ADPs have tables, but they are different. MDBs can link to tables or have tables st