DAP Icon

Version 3.67           First Published 16 Aug 2023                 Last Updated 3 Sept 2023                 Approx 8 MB (zipped)


Section Links:
            Main Features

1.   Introduction Return to Top

This is a significantly enhanced version of my Table Analyzer & Viewer Pro utility. It is designed to analyze a wide range of items in any external Access database without opening it directly.

It should be particularly useful when taking over existing applications from clients where a detailed understanding of the structure and size of each database object is an important first step in planning any work required.

For example, tables with a large number of fields and/or complex datatypes may be a prime candidate for restructuring.
Similarly for tables which occupy a large disk space.

Features include:
a)   view and analyze database objects, object metadata and get object sizes.
b)   view table data and table design.
c)   view table fields and field properties.
d)   View query properties, design, SQL and data
e)   view relationships and VBA references
f)   get a complete list of VBA procedures and view code
g)   view object dependencies
h)   view database properties

A wide range of reports are also available.

2.   Main Features Return to Top

a)   Splash screen (OPTIONAL)

Splash screen
b)   Welcome screen (OPTIONAL)

      Outline of the purpose and features of the application.

Welcome screen
      Several training videos are available from this screen. For example:

Training video
c)   Main form - running analysis

      Browse to select a database to analyze. Progress bars provide detailed information whilst the analysis is running. The analysis can be cancelled at any time.

Progress Bar
      When the analysis has completed, various options are available for viewing the results as shown in the screenshots below.

d)   Database Objects

      Detailed information about each object including object type / default view / object size and whether the object is hidden or system.
      Each object can be saved as a text file for backup purposes or for importing into another database.

e)   Object Metadata

      Information about each object as shown in the navigation pane: date created / date last modified and optional description.

f)   Table Info

      Detailed information about each table including table type (local / linked / system), number of fields, number of records and table size in kilobytes.
      For linked tables, the type of data source is listed. Table designs and datasheets can also be viewed from this subform.

g)   Fields Report

      Available from the field column on the table info subform.
      Detailed information about each table field including datatype / indexing / field size and whether zero length strings are allowed or field data is required.

h)  Relationships Info

      Detailed information about each relationship including table names & join fields, relationship type and whether referential integrity has been set.

i)   Relationship Detail

      Additional detail for an individual relationship.

j)   Relationships Diagram

      Relationship info as a diagram.

k)   Query Info

      Detailed information about each query including the query type, number of fields, records and parameters.
      Queries can be viewed in design view, SQL view and as a datasheet.

l)   Query SQL

      Example SQL for an individual query.

m)   List of VBA Procedures

      List of all code modules and procedures including procedure type / scope and number of code lines. VBA code for each can be viewed.

n)   VBA Code

      Example of VBA code for a selected procedure with colour formatting.

o)   Object Dependencies

      Number of dependencies and dependant objects for each form / report / table & query. Objects with 'orphaned dependencies' are identified

p)   Dependency Report

      Full dependency report listing all object dependencies and dependant objects

q)   VBA References

      List of all VBA reference libraries in the selected database. Any broken (MISSING) references are identified.

r)   Reference Report

      Reference library report with additional information.

s)   Database Properties

      Full list of database properties including property type and value.

t)   Full Analysis Report: Pages 1 & 2 (of 138)

      The output of all analyses completed can be viewed as a single report complete with a table of contents.

u)   Analysis Options and Application Settings

      This form is used to set various program settings and determine which type of analysis are done.

v)   Analysis History

      This form shows a history of all completed analyses including the options used and whether a backup was made.

w)   License & Activation

      This screen is used to enter the license key supplied on purchasing the full version.

License Info
      After entering a valid license key, you will need to activate the product after which it will become fully functional.


3.   Downloads Return to Top

      A free evaluation version is available to download so you can test the application features before purchase.

      The evaluation version is restricted to analyzing a sample database supplied with the application

      Click to download the correct version for your Office installation:

            32-bit Evaluation Version for Access 365       EXE file (approx 8 MB)

            64-bit Evaluation Version for Access 365       EXE file (approx 8 MB)

            32-bit Evaluation Version for Access 2010 (or later)       EXE file (approx 8 MB)

            64-bit Evaluation Version for Access 2010 (or later)       EXE file (approx 8 MB)

      As this is a new application, you may see a Windows SmartScreen warning when you download any of theses files. Don’t worry – its perfectly safe!
      I have asked Microsoft to clear the smart screen warning but that usually takes a few days to implement.

      If you are unsure how to bypass smart screen warnings on downloaded EXE files, please see my article Manage Windows SmartScreen Warnings

      a)   The download files each include an evaluation version of the analyzer (ACCDE), the sample database for analysis (ACCDB) and a PDF help file.

      b)   If you purchase the application, you can convert the analyzer to the full version by entering the license key supplied and then activating the product.
            See video 6 (Evaluation, Purchase & Activation) for further details

4.   Purchase Return to Top

      The full version of the Database Analyzer Pro (DAP) application is now available to purchase. Click this link to purchase the application.

      The application is supplied as a 32-bit or 64-bit ACCDE file.
      A help guide, several training videos and 90 days email support is included with the application.

      The application is mainly aimed at experienced Access developers wishing to analyze their own or client applications.

      The license will entitle purchasers to install the application on 2 computers (business or personal).
      Additional licenses can also be purchased if required.

      Recommended minimum hardware/software specifications:
      •   Intel i5 CPU with minimum 16GB RAM or more
      •   Windows 10 or later; A2010 or later (32 or 64-bit)
      •   14+ inch monitor; Screen resolution 1680*1050 or higher
      •   NOTE: The app uses automatic form resizing so it will adjust to any screen size / resolution

5.   Videos Return to Top

      Although it is should be easy to use, a series of training videos have been created to support new users of this application.
      These can be watched from the Welcome screen of the application.

      The videos are also available from the Database Analyzer Pro video playlist on my Isladogs YouTube channel.

      Alternatively, you can watch each of the videos below:

      a)   Introduction (04:30)


b)   Options & Analysis (05:53)


c)   View Analysis Results (25:27)


d)   Analysis Reports (08:00)


e)   More Options & Analysis History (08:43)


f)   Evaluation, Purchase & Activation (07:14)


g)   Access Europe Meeting (Wed 6 Sept)   (59:10)

        The application was also demonstrated to the September meeting of the online Access Europe User Group (AEU).
        All AEU meetings are recorded and the videos uploaded to YouTube.


6.   Acknowledgements Return to Top

      Many thanks to various people who have provided valuable assistance and feedback during the development of this application.
      Particular thanks are due to:
      a)   George Hepworth - for detailed testing of several early versions and providing access to Azure SQL and Dataverse data
      b)   Angel Mazo - for providing valuable feedback on language-specific issues
      c)   Crystal Long - for allowing me to use a modified version of her Color VBA Code utility
      d)   Chris Arnold - for various code suggestions which may be incorporated into future versions

7.   Feedback Return to Top

      An online feedback form is available for users of the full or evaluation version of the application

      Alternatively, you can use the contact form below to provide feedback or if you have any questions about this application.

Colin Riddington                       Mendip Data Systems                       Last Updated 10 Sept 2023

Return to Home Page

Return to Top