KB960715 (IE7) is breaking Access apps
Graham Mandeno, Access MVP, have found, that latest security update for IE7 breaks Access applications using some of Microsoft ActiveX controls. Details below:
Access applications that incorporate certain VB6 ActiveX controls are failing on computers when the "critical security update" KB960715 is installed.
The update sets "kill bits" that disable certain third-party and Microsoft ActiveX controls, including the following:
Microsoft Animation Control 5.0
Microsoft Chart Control 6.0
Microsoft Animation Control 6.0
Microsoft DataGrid Control 6.0
Microsoft FlexGrid Control 6.0
Microsoft Hierarchical FlexGrid Control 6.0
Microsoft Masked Edit Control 6.0
Microsoft WinSock Control 6.0
Any form that uses these controls will give errors such as "There is no object in this control".
Any attempt to delete the ActiveX control and rebuild the form gives the error "Microsoft Access does not support this ActiveX control".
Another KB article, KB957924, is a cumulative update rollup for VB6.
It includes newer versions (18.104.22.168) of the above controls that do not have the security vulnerability.
Unfortunately, this update may only be installed if you have VB6 installed.
However, it is possible to install KB957924 on a machine with VB6 and then deploy copies of the new OCX files to the affected end-user machines.
This workaround is unwieldy, as it requires an administrator to install and register the updated OCX files on every end-user machine.
Microsoft should add the "safe" versions of the affected OCX files to the KB960715 update, so that instead of killing the old versions of those controls, the new, safe versions are installed and registered.
Furthermore, Microsoft should create another download which includes the "safe" versions of these OCX files so that machines that have been adversely affected by KB960715 can easily be updated without the need to have VB6 installed.
And some comments from other Access MVP, Sascha Trowitzsch:
BTW: I am using two tools to activate/deactivate ActiveX controls: