Version 3.67 First Published 16 Aug 2023 Last Updated 3 Sept 2023 Approx 8 MB (zipped)
UPDATE 2 Sept 2023: Both the EVALUATION and FULL VERSIONS are NOW AVAILABLE
|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.
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)
b) Welcome screen (OPTIONAL)
Outline of the purpose and features of the application.
Several training videos are available from this screen. For example:
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.
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.
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