On 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,
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.
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)
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
Our list of all the internal Microsoft Access error numbers and error descriptions now has a database with the descriptions by Access version in a table. Use it as a reference or for your own lookups across Access versions.