no licence for comdlg32?!

[dverdi]

I hope this is the right forum to post this.

At the new workplace I have just started at, I have been asked to write a MS-Access application (using a licensed 2002 copy under Windows XP Professional).

Everything is going fine (though some of the SQL statements made me pull my hair out). However on one of the Forms it has been declared that I have to find a filename for a Drawing file.
So I add a commondialog control to my Form, and suddenly I get an error message saying:

"You don't have the license required to use this ActiveX control"

I haven't seen this before, and have no idea where to find the licence.
I have tried "regsvr32 comdlg32.ocx", which says it worked successfully, but I still have the problem

Can anyone tell me how to get the licence info up-to-date? Do I have to re-install Access/MS-Office?

 

[SonOfEmidec1100]

Somewhere is a reg file that installs the license VBCTRLS.REG. On the cd that provided the ocx is a good place to start.

 

[dverdi]

Unfortunately I don't know where this control came from, since it was already on this PC when I started work at this company. It just seems to be something common and basic to Microsoft applications, as I have used it at other workplaces.

I have just spent way too much time re-installing everything on my PC several times, from the Windows XP O/S to Office and Nortons Anti-virus for no apparent benefit.

I think I lost my registry twice, had the most unhelpful messages regarding Norton's Anti-virus (had to go back to 2003 version after I couldn't get 2004 to work properly under this re-install of Windows), and my Start - All Programs menu has only a tenth the entries it had before. It is going to take me ages to get my system setup like it was before.

Worst of all, now I can't even find the comdlg32.ocx file anywhere on my PC. I can find a DLL, but that is all. Apparently somewhere during the process it got uninstalled and never re-installed.
Nor can I find the vbctrls.reg file either.

Now I am pissed off. All I wanted to do was use a basic control like I have done before.

Does anyone have any idea what I should do next? Is there an alternate control?

 

[johnwm]

Most likely you have installed a newer version with a new app, then uninstalled the new app. This can leave the wrong registry information in place.

You can usually solve this by renaming the existing comdlg32.ocx, unregistering with regsvr32 /u, then renaming back to normal and re-registering

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[dverdi]

Thanks for the suggestion, but I am afraid to play any further with Windows settings.

Fortunately I found the following article on API calls that does exactly what I need:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima01/html/ima1101.asp

 

[dverdi]

Sorry johnwm,
I wouldn't be able to follow your advice anyway.
I can't rename the existing comdlg32.ocx because somewhere during the re-install process it was removed from my PC.
I don't even know which installation would be supposed to put it on my PC. My guess is Office, because that has Access and the VB editor.

 

[jordan502]

I have just gotten the same error with ms access while trying to embed from the tools options... but knowing that it was a licensing issue for activex controls, I decided to install MS Visual Basic Pro, and voila! Problem solved. Apparently, somebody who only has Access isn't considered to be knowledgeable enough to be embedding simple tools that are included with Access in the first place.

 

[dverdi]

G'day Jordon502,
Thanks for more perspective on the problem.
As far as I can tell, no version of MS-Visual Basic apart from the Acess VBA editor was ever installed on the work PC I was using. So I don't really know how or where the comdlg32.ocx control came be on the work PC I inherited in the first place, or why it wasn't licensed. Bringing it to the attention of my manager actually got all the PCs here at work checked for unauthorised software installations.
Fortunately the API calls have all the functionality I need.

 

[Technician]

Hello dverdi,

I have had nothing but troubles trying to deploy DTPicker with my Access 97 application. MSCOMCT2.OCX is where DTPicker was and on a Windows 98 machine it registers properly. When we started to use Windows 2000 and XP machines all hell broke loose.

I was using 2 DTPicker controls on my form and sometimes 1 would be OK and the other would have an error.

I could not find anywhere on the internet how to properly redeploy this OCX.

I recently found this

http://support.microsoft.com/default.aspx?scid=kb;EN-US;193366

Your specific OCX is here

http://activex.microsoft.com/controls/vb6/COMDLG32.CAB

The CAB file has an INF file along with the OCX.

Do you need a license??? I dunno.

This worked fine for me.

 

[Goondu]

Hi dverdi,

You still have problems with the activeX control?(for Access)

Well, today i had a similar problem. To cut the story short,
i had download a activeX. "regsvr32" it and was registered. When i insert the activeX, i had the same problem as you.

I think microshaft had us all fooled into thinking about that message. It just a warning message about the licence policy from developers.

Ok, here is what i did,
1. Open Access
2. Open database
3. New form
4. Click VBE (icon call Code)
5. Tools - Referances - click Browse
6. locate the activex file (ocx)(click combo box File Type)
7. The add referance box will register your activeX into the list box on the left pane.
8. Click OK

There it was DONE!!!

Try it out on the new form you open and insert the activeX.

HTH