Dec 26

Total Access Statistics Update for Microsoft Access 2010, 2007, and 2003

Microsoft Access 2010

We are very pleased to release an update to Total Access Statistics for Microsoft Access 2010, 2007, and 2003. If you are an owner of version 14.0, 12.8, and 11.8 respectively, you can download the update at no charge.

Total Access Statistics is the most popular data analysis program for Microsoft Access. It extends the data analysis capabilities of Access queries to let you perform advanced numerical analysis on your data. Use any Access table, linked table, or query to perform calculations such as percentiles, regressions, frequency distributions, t-Tests, correlations, non-parametrics, rankings, moving averages, etc. It can also perform data normalization and let you select random records. As you would expect in a query, you can specify Group By fields so analysis is performed on each set of records with identical group fields. Total Access Statistics runs within Access with all output in Access tables. It supports MDB, ACCDB, and ADP databases.

The update includes these enhancements:

  • Significant performance improvements when processing large numbers of records
  • While analyzing records, a new status form appears with an option to cancel the process
  • Setup program offers machine or current user installation options
  • Resolves all known issues

For additional information, visit the Total Access Statistics Update page.

Aug 22

Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update Requires Fixing

ActiveX ControlOn August 14, 2012, Microsoft released a security update for Microsoft Office that includes an update to the Windows Common Control MSCOMCTL.OCX.

Unfortunately, this update causes problems with existing Microsoft Access, Visual Basic 6, and other applications that use the common control such as the Treeview and ListBox controls. For us, this impacts our Total Access Analyzer program which uses the Treeview control in its database explorer feature. It triggers this error:

Error 459 – Object or class does not support the set of events,
Procedure clsFrmExplorer_TAA.InitForm

Microsoft provides a workaround for this problem in a Knowledgebase article, but it doesn't always work. We've come up with a solution that addresses this problem reliably.

Read our article Fixing the Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update for more details.

Jul 27

Total Access Analyzer Version X.9 Released for Microsoft Access 2007 and 2003

Microsoft Access 2010Microsoft Access Database DocumentationMicrosoft Access Database DocumentationMicrosoft Access Documenter

Total Access Analyzer is the most popular Microsoft Access product of all-time! In conjunction with the release of the Microsoft Access 2010 version, we've added many of the new features to the Microsoft Access 2007 and 2003 versions.

In addition to the comprehensive documentation and analysis of your database objects, macros, and VBA module code, Total Access Analyzer version X.9 adds:

Detection of Additional Errors and Suggestions

  • Timer Interval and Timer Event Mismatch
  • Queries Using Other Queries with Both having GroupBy Clauses
  • Action Queries Opened by OpenQuery Command
  • SQL Server list of reserved words updated for SQL Server 2012

Displaying Additional Documentation Results

  • ActiveX controls appear as a New Category under General
  • New Table-Fields folder under Tables lets you view field properties across all your tables in one screen
  • Enhanced Opening of Referenced Object in Design Mode (view the documentation and immediately jump to the object to make changes)

Report Enhancements

  • Preview Multiple Reports at One Time
  • Color Customization for Reports
  • Enhanced Macro Dictionary Report
  • Many New Reports

New Module VBA Documentation and
Options for Microsoft Access 2007

Improved User Experience

  • Support for Windows 7 (in addition to XP and Vista) and Office Themes
  • Installation options for the current user or machine, with support for User Access Control permissions

Existing customers with premium support subscriptions receive the upgrade for free. Other existing customers can upgrade for a nominal fee. Demo Available