Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

0
10 Posted

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

0
10

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

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.