CODEWITHSUNDEEP
vbams-accessactivex
Teson
Teson

Reputation: 6736

MS-access doesn't catch treeview events after win sec-update

Access 2010-application using TreeView (MSComctlLib.TreeCtrl.2) shows and populates as expected but suddenly after windows security patches doesn't fire events back to VBA.

Tried with rolling back MSCOMCTL.OCX in /syswow64, but no luck.

Please ping any similar behaviour or hints for fixing the issue.

regards,

Upvotes: 4

Views: 6273

Answers (2)

StockB
StockB

Reputation: 774

I opened an Access file developed on 32-bit Access 2013 running on Windows 7 32-bit, and had experienced this problem when opening it on 64-bit Access 2013 running on Windows 8 64-bit.

My solution:

Delete the control and add it back again, using the design view on your Access form.

Because the treeview's properties are mostly set programmatically, there should be little to do aside from repositioning it and renaming it.

Upvotes: 1

Andomar
Andomar

Reputation: 238126

The problem appears to be that the registry entries for mscomctl.ocx are broken after the security update. One solution can be found in this KB article. It suggests to run this batch file as administrator:

reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f
if exist %systemroot%\SysWOW64\cscript.exe goto 64 
%systemroot%\system32\regsvr32 /u mscomctl.ocx
%systemroot%\system32\regsvr32 mscomctl.ocx
exit
:64 
%systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx
%systemroot%\sysWOW64\regsvr32 mscomctl.ocx
exit

I've verified that this works in our environment.

Upvotes: 3

Related Questions