The Analyzer, which runs in Microsoft Access, documents databases, is menu-driven, easy to use, and generates valuable information for developers and users with databases such as Access, and anything Access can connect to such as SQL Server and Oracle.
Switch branches/tags
Nothing to show
Clone or download
Latest commit 8ef5ca9 Jul 3, 2017
Failed to load latest commit information.
Analyzer_170317_s4p_Loop.accdb March 2017 Analyzer Jul 1, 2017
LICENSE.txt Create LICENSE.txt Jul 3, 2017 Create Jul 3, 2017


The Analyzer in Microsoft Access is menu-driven, easy to use, generates valuable information -- useful for users, developers, designers, managers, and anyone who uses Access (and databases Access can connect to such as SQL Server)

The Analyzer documents databases, which can be SQL Server or other big data -- and Access too, of course. Use the Analyzer to create a list of table names, data dictionary, relationships, indexes, statistics about your data, and more. In addition to being able to see all the code, you also see the the Analyzer results and use them however you wish; this this is invaluable tool for a developer.

The latest version of the Analyzer can loop through the directory of the database you choose and analyze multiple files. It is designed such that, if a list of databases to analyze were already in LF_Files, they would all be done. New Reports for Combined results.

The Analyzer can analyze big data, like databases that have links to SQL Server tables. Yes, the Analyzer easily documents what you have in SQL Server (or other big data) ! Simply link to tables from Access and analyze the database with links. Save the username and password in the connect string (you can delete a temporary Access database after the Analyzer is done).

When analyzing big data, the Analyzer can take awhile to run, especially if you do the Value Analysis test. While running, you will see "Not Responding". This is normal and nothing to be concerned about.

Instructions for analyzing SQL Server databases:

The Analyzer gets a ton of information about your tables, fields, indexes, and relationships. It also reads what is defined for forms and reports -- names, sources, controls, groups, sections, conditional formatting, and more.

Watch the 5-minute DEMO VIDEO on YouTube:

It is recommended, as a general rule, to put the initial Analyzer download after unzipping into a reference folder you can find again. When you want to analyze a project that is not related to other projects you have analyzed, make a copy of the blank Analyzer database to your project folder and then run the Analyzer.

The Analyzer is distributed as one file for ease of development. Splitting tables into a back-end is your option. What does the Analyzer do?

The Analyzer shows you what is in your database ... tables, fields, properties, relationships, indexes, ... data ... forms and reports, .... Looking at data is just as important as looking at structure. The Analyzer provides a way to document, understand, and optimize your database. Because it can also analyze the data that is stored, the more records you have in the database when you analyze it, the more the Analyzer can tell you. Analyzing the same database on a regular basis is valuable to compare the number of records and value statistics in each table.

The 5 basic Analyzer reports are:

Table Summary
Deep Analysis (Data Dictionary + Value Analysis)
Field List
Table Indexes

Additional reports include:

Lookup Fields
Database Information
Linked Databases
Table Detail
Field Statistics
Object Summary
Form Record Sources
Form Control RowSources
Font Styles
LOOK in Form Control or Row Source (prompts for a parameter).  

There are more than 50 reports, including reports to aggregate information about multiple databases.

What do you want to see? The Analyzer probably gets the data you need and if not, consider developing another Test for it. How much does the Analyzer cost?

The Analyzer is free. All development is volunteer.

Code and suggestions for the Analyzer have come from many including Allen Browne, Bill Mosca, Mark Davis, A.D. Tejpal, Wayne Phillips, Arvin Meyer, Terry Kreft, Stephen Lebans, Tom Wickerath, Brent Spaulding, Kent Gorrel, Adrian Bell, Anders Ebro Christensen, Matthias Hagedorn, Patricia Hartman, Pat Wood, Jack Leach, Jack Cowley, Randy Dorian, David Pimental, Richard Mullen, Angel Matos, Tom van Stiphout, Thomas Möller, John Mishefske, Henry Habermacher, James Ranck, José Dumoulin, Graham Mandeno ... and many more ~ thank you ~

"If I have seen further it is by standing on the shoulders of giants." -- Isaac Newton

Through sharing, we will all get better ~ have an awesome day ~