Dependency Report

Before I retired, I was able to use FMS's Access Analyzer and Speed Ferret for cleaning up Access projects before release. My current MS Access development work is for personal use or for that of f...

Id #1359 | Release: None | Updated: Dec 7, 2016 at 7:07 AM by strive4peace | Created: Dec 1, 2016 at 5:25 PM by panamaed

enable vbWatchdog at startup

Now that vbWatchdog v3 is integrated into the project, we should enable it during startup so that we can start logging extensive details of unhandled VBA errors. We can later expand this to includ...

Id #1182 | Release: None | Updated: Jul 15, 2014 at 6:42 PM by wayne_phillips | Created: Jul 14, 2014 at 6:38 PM by wayne_phillips

Data type conversion error

Hello, I installed Analyzer_140702 posted by Crystal on July 02. I use Access 2010. The program compiles OK but when I run it, the line : rsData (sFieldName). Value = varValue causes a "Data Type c...

Id #1178 | Release: None | Updated: Jul 9, 2014 at 9:07 AM by Voodoo37 | Created: Jul 9, 2014 at 9:07 AM by Voodoo37

Lookups fields do not always have RowSource

Lookup fields do not always have a RowSource. In mod_Analyzer_110_LookupFields, this statement needs to change to keep the Analyzer from crashing. !theSQL = fldAnalyze.Properties("RowSource") ma...

Id #1174 | Release: None | Updated: Jul 2, 2014 at 2:54 PM by strive4peace | Created: Jun 29, 2014 at 2:05 AM by strive4peace

Relationships report - show relationship attributes

On the right side of the Relationships report, show the Relationship attribute string, not the Field attribute string. Fixed 140626.

Id #1173 | Release: None | Updated: Jun 26, 2014 at 5:32 PM by strive4peace | Created: Jun 26, 2014 at 5:32 PM by strive4peace

Table Indexes report -- show PK tablename + field

On the right side of the Table Indexes report, the Table and Field names displayed should be the main table for the relationship that was set up to enforce referential integrity. Fixed 140626.

Id #1172 | Release: None | Updated: Jun 26, 2014 at 5:31 PM by strive4peace | Created: Jun 26, 2014 at 5:31 PM by strive4peace

Analyzer Stops when on ODBC connection is missing

When running the tests in the analyzer, the data dictionary seems to fail when the code can not find the DSN for an ODBC connection. It appears to mark the Data Dictionary complete (TestName goes ...

Id #1165 | Release: None | Updated: Jun 17, 2014 at 7:02 PM by EdPerkins_jr | Created: Jun 17, 2014 at 7:02 PM by EdPerkins_jr

Comparing Databases

The Analyzer currently has no reports to summarize different related database that have been analyzed. Provisions have been made on the form that can be taken advantage of for filtering : BatchID...

Id #1159 | Release: None | Updated: Jun 7, 2014 at 11:36 PM by strive4peace | Created: Jun 7, 2014 at 11:36 PM by strive4peace

Split into FE/BE

Build an interface to users to identify existing BE to use (it will need to have a description) or create a new BE when getting ready to analyze a database. BE template database will need to be in...

Id #1158 | Release: None | Updated: Jun 7, 2014 at 11:28 PM by strive4peace | Created: Jun 7, 2014 at 11:28 PM by strive4peace

extend the Analyzer to Document Excel

Allow user to indicate they want to document and Excel workbook and prompt for file types accordingly. Add tests to enumerate sheets, sheet types, how many rows and columns and filled cells, how ma...

Id #1157 | Release: None | Updated: Jun 5, 2014 at 6:17 PM by strive4peace | Created: Jun 5, 2014 at 6:17 PM by strive4peace