Please Help with Access 2003 and ActiveX Controls

Hot Topic

My buddy experience so far
OutPutTo Macro
DLL/OCX Redirection from Word template
Problem With Code That Writes a Change To Itself
Problem sorting dates!
Custom button on control bar
How to open Access files and export them to Excel
need help for VBA code(MS Access)
Odd or even and converting Decimal to binary, octal, or hexadecimal and back.
has anyone done the tests at all?!

Microsoft ISV

How print picture
Lack of mouse scroll wheel support in VBA
Dialog Box, Searching for keywords in an Excel Workbook
copy chart from excel to word
Save Each page of a Word merge as a seperated pdf file
Windows media files have changes to Nero
Closing a dependent file in Excel97
Setting Chart Title through VBA sometimes works sometimes doesn't.
Distributing a Macro across an organization - how to delete existing .bas files within a .dot file?
Table Caption Property

Please Help with Access 2003 and ActiveX Controls

Hello everyone,
 
    I am having a major problem and I can not find a resonable answer any where, so I hope some one here can help me out.  I have been working with Access 2000 for a long time and have always been able to Insert the ActiveX control "Microsoft Common Dialog control, version 6.0".  I now have made the jump into Office 2003 and Access 2003 which when I try to Insert the ActiveX control "Microsoft COmmon Dialog control, version 6.0" I get the following error: "You dont' have the license required to use this ActiveX control." 
   Can I assume that Office 2003 Professional does not have the Design Time License for this control now   If that is the case what do I need to get the License.  Please someone help me!

Thank you
BadMojo



Answer this question

Please Help with Access 2003 and ActiveX Controls

  • bkavanaugh

    Brenda,
    Thank you for your response. I won't kow just yet if it will work, but I'll certainly let you know if it does.
    Thanks again,
    Lorna


  • farkewie

    The Access 2003 Developer Extensions might be what you're looking for:

    http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx

    You might find the Access Developer Center on MSDN to be a great resource for you as well. http://msdn.microsoft.com/office/

    -brenda (ISV Buddy Team)



  • Fernik - 460332

    Thank you very much for the help. Is there then a Access 2003 Developers edition

  • Idan Hollander

    Hi,

    I used Access XP and we decided to upgrade to Access 2003 but I ran into a similar error when I tried to add Microsoft MonthView control 6.0 (SP2). I know that this is MSCOMCT2.OCX so I search for the file and sure enough I didn't find it on my computer, however, the strange thing is other machines that also have office 2003 did have MSCOMCT2.OCX in C:\Windows\System32\ folder!!!

    I can add some ActiveX controls but there are others that I can't add, like mMSCOMCT2.OCX, so does this means that the ones I can't add I need to buy Microsoft Access 2003 developer edition

    I read somewhere that I can download the ocx and register it using regsvr32.exe, will that works fine

    The otherthing that I don't understand is that why should I buy the developer edition when we have bought the full version of microsoft office for each PC!

    MANY THANKS!

  • ohanlonp

    Per our support engineer:

    The error is because Office 2003 no longer ships with the ActiveX controls. We can refer to the following article:
    310803 How to resolve reference issues in an Access database
    http://support.microsoft.com/ id=310803
    The Common Dialog control uses the following file: COMDLG32.OCX. Its dependencies are: COMCAT.DLL and COMDLG32.DEP.
    To use the control properly on the machine with Access 2003 installed, we should use Office 2000 Developer to create a package that includes the controls and their dependency files and install it on the machine with Access 2003.
    Distributing Database Files That Have ActiveX Controls
    ------------------------------------------------------
    There are two types of licenses for ActiveX controls: a design-time license and a run-time license.

    - A design-time license permits you to insert licensed ActiveX controls from Office 2000 Developer into forms and reports in an Access database.
    - A run-time license permits you to use the ActiveX controls in an Access database on a computer that does not have Office 2000 Developer installed, but a run-time license does not permit you to insert new licensed ActiveX controls. To install a run-time license, distribute the ActiveX controls by using the Package and Deployment Wizard, which writes the license for the controls in the target computer's registry.
    If you distribute a database file without installing the distributable Common Dialog control, the control's reference may be flagged as Missing, or you may receive an error message that "You don't have the license required to use this ActiveX control" if the non-distributable control is already installed on the target computer.
    Even when the database file is part of a run-time application, you may receive the error message that "You don't have the license required to use this ActiveX control" if the non-distributable control that is already installed on the target computer is of a later version than the control that is provided by your run-time application. This issue can occur because the Setup program does not overwrite later versions of a file with an earlier version of the same file.

    Related Knowledgebase Articles:
    ===========================
    310803 How to resolve reference issues in an Access database
    http://support.microsoft.com/ id=310803

    305528 OFF2000: How to Distribute ActiveX Controls
    http://support.microsoft.com/ id=305528
    310814 ACC2000: ActiveX Error When You Open a Database That Does Not Use
    http://support.microsoft.com/ id=310814

    Additional Information and Recommendations:
    =====================================
    HOW TO: Keep a Jet 4.0 Database in Top Working Condition (Q300216)
    http://support.microsoft.com/default.aspx scid=kb;en-us;Q300216

    -brenda (ISV Buddy Team)



  • Matt j Cimino Crawford

    Hi together

    late, but I found it.

    But why the hell I have it in my VBA Control's List when I'm not allowed to use.
    Does someone have already heard something about a clean system...

    Sorry I forgot, we speak about Windows ;-))

    An angry user, one's more.
  • Please Help with Access 2003 and ActiveX Controls
Answer this question