Database Analyser

[NeoPa]

Thanks for posting Crystal. Feel free to keep this thread updated with any new features you develop.

[strive4peace]

hi Adrian,

thanks for posting. I'm here now (smile). The link you provided is still good and has a lot of information on how to learn more about what the Analyzer stores so it can benefit you even more. There is also an Access 2000 version to download for MDB users, but it doesn't have near the features of the latest and greatest version, which is an ACCDB.

The current public version, which is still free of course, is on GitHub.

https://github.com/strive4peace/Analyzer

There are more than 50 reports and all the data is readable, as is the code.

I am currently working on an extensive data dictionary report to Word which will go into the next release. Also in the next release will be documenting macro content -- standalone & embedded, and data macros.

The Analyzer is a developer tool ... and nice for anyone who uses Access since it has menus so you can just run it and look at reports too.

respectfully,
crystal

~ have an awesome day ~

[NeoPa]

Feel free to comment if you find out Z. My experience with the built-in analysis (which has been available for many versions in one way or another) is that it is pretty unreliable and doesn't include everything it should. I can't quote chapter end verse but there are articles and threads out there which discuss it, as I found out some while ago when I almost started something similar from scratch myself.

[zmbd]

Also in V2010 under the database tools there is a similar tool. Would be interesting to do a compare/contrast between the two.

[NeoPa]

This article is simply a link to a product (Analyser by Crystal), provided as donate-ware (Free to use.), from Crystal Long, an Access MVP.

The structure of what it provides is included here, as an introduction and a taster :

Database Analyzer Reports

Table Summary
Deep Analysis
Field List
Relationships
Table Indexes

Analyzer Data Structure

Relationship Diagram
Design of Tables
Design of Flds (Fields)
qFields Query

qFields Design
qFields SQL
qFields Datasheet View showing Flds table

Take Time
Customize the Analyzer

Make a Master Database
Copy My Analyzer Database
Create Tables
Add Fields
Plan and Perform Data Transfer

I believe it could prove very useful to a great number of our members and visitors alike.

Feel free to post comments on what you find and how helpful it proved. Bear in mind Crystal is not known to visit here herself, so any criticisms or improvement suggestions for her attention should probably be sent to her (or her site) directly (Comments).