MSComctlLib.ListViewCtrl.2

[kengo]

I have a Microsoft Access (2007) form which has worked for some time now
using MSComctlLib.ListViewCtrl.2. I just tried to use it today and received
this error 'There is no object in this control.' When in form design mode if
I try and add the 'Microsoft ListView Control 6,0 (SP4) I receive the
following error 'You don't have the license required to use this ActiveX
control.'

Any ideas why it quit working and maybe a solution?

 

[Tony Toews [MVP]]

I have a Microsoft Access (2007) form which has worked for some time now
using MSComctlLib.ListViewCtrl.2. I just tried to use it today and received
this error 'There is no object in this control.' When in form design mode if
I try and add the 'Microsoft ListView Control 6,0 (SP4) I receive the
following error 'You don't have the license required to use this ActiveX
control.'

Killbits got recently set on lots of Microsoft and other vendors
controls via Windows Updates due to security risks in the controls.

I *THINK* the most recent version of these controls is at the
following web page.

Description of the cumulative update rollup for the Visual Basic 6.0
Service Pack 6 Runtime Extended Files
http://support.microsoft.com/kb/957924

You will need to download and install the updates on your system to
test. Then you will need to distribute a new version of the OCX(s)
to your users as well as a new copy of your FE MDB/MDE/etc. As
installing and registering the OCX will require admin privileges this
will need to be coordinated with your IT department.

Tony

 

[kengo]

Tony,

Thanks. The killbits are a nice touch. I'll give it a try.

kengo

 

[Tony Toews [MVP]]

Thanks. The killbits are a nice touch. I'll give it a try.

I've got the following working but haven't yet figure out how to
replace the OCX file on my system for testing and to distribute it.
More research required that won't be able to happen for a day or
three.

To locate the most recent copy of the OCXs download the MSI file from
Microsoft Visual Basic 6.0 Service Pack 6 Cumulative Update

To extract files from a .msi file at the command line, type:

msiexec /a PathToMSIFile /qb TARGETDIR=DirectoryToExtractTo

So on my system it's

C:\>msiexec /a "C:\9 archive\Software
installed\VB60SP6-KB957924-v2-x86-ENU.msi" /qb targetdir="C:\temp\VB6
SP6"

For example the mscomctl.ocx file is version 6.1.98.16 dated 2009
March 24. On my system mine is version 6.1.97.86 dated 2002 December
20. (I have no idea how it is that this old of a file still works
when I try using it in Access.)

Tony

 

[kengo]

Tony,

I tried to install update by double clicking and your method, both fail
miserably. I do not have Visual Basic 6.0, but I do have Visual Studio 2005
and 2008. Should not either one of those have the updated controls?? This
is all very frustrating.

Thanks for your help, kengo

 

[Tony Toews [MVP]]

I tried to install update by double clicking and your method, both fail
miserably. I do not have Visual Basic 6.0, but I do have Visual Studio 2005
and 2008. Should not either one of those have the updated controls?? This
is all very frustrating.

I have a partial solution.

You can extract the files from the cumulative update by using the
following:

To extract files from a .msi file at the command line, type:

msiexec /a PathToMSIFile /qb TARGETDIR=DirectoryToExtractTo

However I'm not sure how to actually get those updated into your
system so you can test them and redistribute them.


Tony