This project has moved. For the latest updates, please go here.

Analyzer in Microsoft Access

The Analyzer has moved to GitHub.

GitHub.com/strive4peace/Analyzer

Through the years that the Analyzer has been available, and on CodePlex, many have contributed ideas and code -- thank you.  I look forward to continuing the collaboration on GitHub.

The Analyzer, which runs in Microsoft Access, provides valuable information about databases. It is menu-driven and easy to use. Who benefits? Developers and users of Access applications, as well as anything Access can connect to such as Excel, SQL Server, Oracle, and ODBC-compliant databases.

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.

Instructions for analyzing SQL Server databases: https://analyzer.codeplex.com/releases/view/629396

The Analyzer gets a ton of information about your tables, fields, indexes, and relationships.  For Access, 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: www.youtube.com/watch?v=st3dcpVjwl0

If what you are analyzing is Access, database objects such as Forms and Reports are also analyzed.  

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 the LF_Files table and properly marked, they would all be done. 

The Analyzer can also 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.

The Analyzer is complex and gathers a lot of information. Some of is reported but much is not ... build your own queries and reports to see more.


Conditional compilation for 32 or 64-bit added by James Ranck (SuperShadow). OpenBypass by Adrian Bell. Testing and bug reporting by José Dumoulin. Help from Henry Habermacher.  vbWatchdog for error handling and reporting, splash screen, and sort bug fixed by Wayne Phillips. Date issues fixed by Graham Mandeno.   These are awesome enhancements! Fantastic work!

If you have issues with downloads, clear Read-only checkbox and click Unblock for the File Properties (right-click file and choose Properties).  Compile database on your machine.



The Analyzer is an Access database. Access 2000 version is posted on: 

http://www.AccessMVP.com/strive4peace/Analyzer.htm

After unzipping, put the initial Analyzer download 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, or subfolder, and then run the Analyzer.

The Analyzer is distributed as one file for ease of development.  Splitting 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
  • Relationships

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.

Development Team

The Analyzer was originally written in the 90's by crystal. Through the years, it has gotten bigger and bigger ... always more to do. "With the addition of several other authors, it has grown to be the signature program of its kind." said Arvin, who has also written lots of documentation programs.

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 ~

Great efforts have been made to provide a structure for the code and features to make the Analyzer modular so it is easy to isolate code you want to focus on and add to.  It is the hope that you and the Access developer community will come together and expand the Analyzer to freely share with everyone.

If you look at the Analyzer results in the tables after you have run some tests, no doubt you will notice many things you'd like on a report .. or other tests you'd like to run.  Your ideas and help are welcome!

The biggest thing lacking is reports! The Analyzer generates lots of information that is not currently on any report.  Building reports is a great way to help. 

While many have collaborated the Analyzer, this is the first time it is being posting on a developer site.  Helpful advice is welcome and appreciated.

Please consider joining the developer team and sharing back to the Access community.

Analyzer Issues

Issues have been added with more to come.  Thank you all for great suggestions through email, PMs, in person, and other ways ~

If you have issues with downloads, clear Read-only checkbox and click Unblock for the File Properties (right-click file and choose Properties).  Compile database on your machine.

Do you want to help?

All suggestions and comments are welcome ... and of course your help! 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 ~

______________________________

If you have stuff to share, since CodePlex is shutting down, here is a good place to start: 

1. create account on GitHub.com

2. create a repository -- public repositories are free 

  • in addition to what you are sharing, create a ReadMe and a License file.  The MD extension stands for "Markdown" and means the file can include markup language.

3. for more informaiton, please refer to:

Last edited Jul 3 at 6:22 AM by strive4peace, version 194