By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,959 Members | 2,432 Online
Bytes IT Community
Submit an Article
Got Smarts?
Share your bits of IT knowledge by writing an article on Bytes.

Database Analyser

Expert Mod 15k+
P: 31,492
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
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).
Dec 6 '12 #1
Share this Article
Share on Google+

Expert Mod 5K+
P: 5,397
Also in V2010 under the database tools there is a similar tool. Would be interesting to do a compare/contrast between the two.
Dec 6 '12 #2

Expert Mod 15k+
P: 31,492
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.
Dec 6 '12 #3

P: 31
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.

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.


~ have an awesome day ~
Aug 13 '17 #4

Expert Mod 15k+
P: 31,492
Thanks for posting Crystal. Feel free to keep this thread updated with any new features you develop.
Aug 13 '17 #5