Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

User does not have license required to open ActiveX Control

Discussion in 'Information Technology' started by Sierras, Jul 28, 2006.

  1. Sierras

    Sierras
    Expand Collapse
    Guest

    I made an Access 2000 database which works fine in Access 2000.
    But a couple of users with Access 2003 get an error message when they
    try to open a report. Everything else (queries and forms) seem to be
    working fine.

    The message is, that the user does not have the license required to
    open the ActiveX Control. This is strange since there is an AcitveX
    calendar control on a form which is working fine. But no ActiveX
    control on the reports.

    What is that and is there a workaround?
    The users have Access 2003 version 11.5614.?

    Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    After FIR, Social Media Users Wary of Offensive Jokes on Sardars Information Technology Oct 2, 2013
    USA US govt secretly collecting data on millions of Verizon users: Report Breaking News Jun 6, 2013
    using spiritual name as a username Questions and Answers Aug 23, 2012
    Audience of 3 Million Users Receiving Anti-Sikh Messages Hard Talk Sep 17, 2010
    General How can I change my username ? Hard Talk Sep 4, 2010

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Go into the VB Editor, and select Tools | References from the tool bar. Is
    there any reference there to an ActiveX control that isn't being used? If
    so, remove the reference.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Sierras" <danick5000@hotmail.com> wrote in message
    news:s8lh72pfk4hrheh4atb53t8gnvtcdt819l@4ax.com...
    >I made an Access 2000 database which works fine in Access 2000.
    > But a couple of users with Access 2003 get an error message when they
    > try to open a report. Everything else (queries and forms) seem to be
    > working fine.
    >
    > The message is, that the user does not have the license required to
    > open the ActiveX Control. This is strange since there is an AcitveX
    > calendar control on a form which is working fine. But no ActiveX
    > control on the reports.
    >
    > What is that and is there a workaround?
    > The users have Access 2003 version 11.5614.?
    >
    > Thanks.
     
  4. Sierras

    Sierras
    Expand Collapse
    Guest

    I unchecked everything that Access would allow and now only have the
    following checked;

    Visual Basic for Applications
    Microsoft Access 9.0 Object Library

    But the user still get the Do not have the license required to use the
    ActiveX control message.

    Any other ideas as to what this could be?


    On Sat, 27 May 2006 19:17:12 -0400, "Douglas J. Steele"
    <NOSPAM_djsteele@NOSPAM_canada.com> wrote:

    >Go into the VB Editor, and select Tools | References from the tool bar. Is
    >there any reference there to an ActiveX control that isn't being used? If
    >so, remove the reference.
     
  5. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    If you try a Recompile All from the Debug menu, any particular error
    message?

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Sierras" <danick5000@hotmail.com> wrote in message
    news:fbth725b819c8cmjs4vqar3th897c5oe33@4ax.com...
    >I unchecked everything that Access would allow and now only have the
    > following checked;
    >
    > Visual Basic for Applications
    > Microsoft Access 9.0 Object Library
    >
    > But the user still get the Do not have the license required to use the
    > ActiveX control message.
    >
    > Any other ideas as to what this could be?
    >
    >
    > On Sat, 27 May 2006 19:17:12 -0400, "Douglas J. Steele"
    > <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
    >
    >>Go into the VB Editor, and select Tools | References from the tool bar. Is
    >>there any reference there to an ActiveX control that isn't being used? If
    >>so, remove the reference.
     
  6. Sierras

    Sierras
    Expand Collapse
    Guest

    There is no error message when the user compiles the database.

    The thing is, I don't have Access 2003 and the users are remote from
    me so it's difficult for me to troubleshoot this problem.

    There are a couple of things that I don't understand about this
    problem:

    1) When the user launches the Access Database, they get some Access
    security messages about possible virus in Access code and that they
    have to install some update to Microsoft Jet 4.

    2) When I have them go into the VB editor and check for references,
    they have MS Access 11 Object Library. But I made the database with
    version 9. Could this be a possible problem?

    Also, I've been reading something about about sandbox mode. I had the
    user check it in the registry and change it from 3 to 2 which is
    supposed to be the default. But that didn't work either. I'm
    wondering if I should ask them to turn it off altogether (if this has
    anything to do with it..)

    The other thing I have asked them to do is to update their versions to
    the latest Service Patches. And check their Windows XP installation
    as well for any update to that Microsoft Jet error they were getting.
    Hopefully this will solve the problem, but if not, I'd appreciate any
    other troubleshooting assistance.

    Thanks...



    On Sun, 28 May 2006 10:27:08 -0400, "Sylvain Lafontaine" <sylvain aei
    ca (fill the blanks, no spam please)> wrote:

    >If you try a Recompile All from the Debug menu, any particular error
    >message?
     
  7. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    When I said recompiling all modules, I mean doing it from Access 2003. Try
    asking one of your user to do so and after that, ask him to repeat the
    process after adding a useless reference to make sure that all modules are
    really recompiled.

    Also, ask them to try with the /decompile option.

    It is normal that there is a change for some of the references in going from
    A2000 to 2003 but as you don't have A2003, it may be hard to find the error
    here. Did you try using the Remote Desktop Connection? Might be a good
    time to start fiddling with it.

    The message about a possible virus in Access code is a *feature* of A2003
    (and a real pain in the a** by the way). Your users will have to lower
    their security setting: Tool | Macro | Security -> Low.

    (If they have upgraded from a previous version of Access, this option might
    be missing from the menu, see http://support.microsoft.com/?kbid=833219 for
    how to solve this.)

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Sierras" <danick5000@hotmail.com> wrote in message
    news:ljgj7293fsmnstm3dc91s28bd0cila7qkv@4ax.com...
    > There is no error message when the user compiles the database.
    >
    > The thing is, I don't have Access 2003 and the users are remote from
    > me so it's difficult for me to troubleshoot this problem.
    >
    > There are a couple of things that I don't understand about this
    > problem:
    >
    > 1) When the user launches the Access Database, they get some Access
    > security messages about possible virus in Access code and that they
    > have to install some update to Microsoft Jet 4.
    >
    > 2) When I have them go into the VB editor and check for references,
    > they have MS Access 11 Object Library. But I made the database with
    > version 9. Could this be a possible problem?
    >
    > Also, I've been reading something about about sandbox mode. I had the
    > user check it in the registry and change it from 3 to 2 which is
    > supposed to be the default. But that didn't work either. I'm
    > wondering if I should ask them to turn it off altogether (if this has
    > anything to do with it..)
    >
    > The other thing I have asked them to do is to update their versions to
    > the latest Service Patches. And check their Windows XP installation
    > as well for any update to that Microsoft Jet error they were getting.
    > Hopefully this will solve the problem, but if not, I'd appreciate any
    > other troubleshooting assistance.
    >
    > Thanks...
    >
    >
    >
    > On Sun, 28 May 2006 10:27:08 -0400, "Sylvain Lafontaine" <sylvain aei
    > ca (fill the blanks, no spam please)> wrote:
    >
    >>If you try a Recompile All from the Debug menu, any particular error
    >>message?
     
  8. Sierras

    Sierras
    Expand Collapse
    Guest

    I did talk to one of the users with Access 2003 and asked to
    recompile. But maybe I didn't direct the user to the right toolbar.
    I asked to press ALT|F11 and then to go to the Debug menu and press
    the re-compile.
    But there is only a "Compile" database available. I don't know where
    to find the "Recompile all modules" dialog. Was this the correct
    procedure that you were talking about? And what do you mean by adding
    a useless reference. Is something like "utility" a useless reference.
    One more thing - I asked the user to remore all references that they
    could - even calendar control. It's funny that the form with calendar
    control still worked normally.

    Also, I will be asking the user to lower their security to see if that
    makes a difference.

    Thanks..


    On Sun, 28 May 2006 13:35:35 -0400, "Sylvain Lafontaine" <sylvain aei
    ca (fill the blanks, no spam please)> wrote:

    >When I said recompiling all modules, I mean doing it from Access 2003. Try
    >asking one of your user to do so and after that, ask him to repeat the
    >process after adding a useless reference to make sure that all modules are
    >really recompiled.
    >
    >Also, ask them to try with the /decompile option.
    >
    >It is normal that there is a change for some of the references in going from
    >A2000 to 2003 but as you don't have A2003, it may be hard to find the error
    >here. Did you try using the Remote Desktop Connection? Might be a good
    >time to start fiddling with it.
    >
    >The message about a possible virus in Access code is a *feature* of A2003
    >(and a real pain in the a** by the way). Your users will have to lower
    >their security setting: Tool | Macro | Security -> Low.
    >
    >(If they have upgraded from a previous version of Access, this option might
    >be missing from the menu, see http://support.microsoft.com/?kbid=833219 for
    >how to solve this.)
     
  9. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Sorry, my error: with Access 2003, it's only "Compile" and not "Compile
    all".

    In the References dialog, adding a dummy reference will make sure that all
    modules recompiled because each time there is a change in references, all
    modules are marked to be recompiled. If there are some incompatibility with
    the compilations of the mdb on your system and on their system, the
    procedure might uncover it.

    It is not necessary to set a reference to the calendar control to create
    one or call it; it's depend on the way you are making these creations and
    calls. References are only necessary for early bindings, not late bindings.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Sierras" <danick5000@hotmail.com> wrote in message
    news:ifqj72pgfmlnckj9b4e8srk930cmri1udt@4ax.com...
    >I did talk to one of the users with Access 2003 and asked to
    > recompile. But maybe I didn't direct the user to the right toolbar.
    > I asked to press ALT|F11 and then to go to the Debug menu and press
    > the re-compile.
    > But there is only a "Compile" database available. I don't know where
    > to find the "Recompile all modules" dialog. Was this the correct
    > procedure that you were talking about? And what do you mean by adding
    > a useless reference. Is something like "utility" a useless reference.
    > One more thing - I asked the user to remore all references that they
    > could - even calendar control. It's funny that the form with calendar
    > control still worked normally.
    >
    > Also, I will be asking the user to lower their security to see if that
    > makes a difference.
    >
    > Thanks..
    >
    >
    > On Sun, 28 May 2006 13:35:35 -0400, "Sylvain Lafontaine" <sylvain aei
    > ca (fill the blanks, no spam please)> wrote:
    >
    >>When I said recompiling all modules, I mean doing it from Access 2003.
    >>Try
    >>asking one of your user to do so and after that, ask him to repeat the
    >>process after adding a useless reference to make sure that all modules are
    >>really recompiled.
    >>
    >>Also, ask them to try with the /decompile option.
    >>
    >>It is normal that there is a change for some of the references in going
    >>from
    >>A2000 to 2003 but as you don't have A2003, it may be hard to find the
    >>error
    >>here. Did you try using the Remote Desktop Connection? Might be a good
    >>time to start fiddling with it.
    >>
    >>The message about a possible virus in Access code is a *feature* of A2003
    >>(and a real pain in the a** by the way). Your users will have to lower
    >>their security setting: Tool | Macro | Security -> Low.
    >>
    >>(If they have upgraded from a previous version of Access, this option
    >>might
    >>be missing from the menu, see http://support.microsoft.com/?kbid=833219
    >>for
    >>how to solve this.)
     
  10. Sierras

    Sierras
    Expand Collapse
    Guest

    Just wanted to let you know that the Tool | Macro | Security -> Low
    setting worked. Since I don't have Access 2003, I would probably
    never have found it.

    Thanks for your help.



    On Sun, 28 May 2006 13:35:35 -0400, "Sylvain Lafontaine" <sylvain aei
    ca (fill the blanks, no spam please)> wrote:

    >When I said recompiling all modules, I mean doing it from Access 2003. Try
    >asking one of your user to do so and after that, ask him to repeat the
    >process after adding a useless reference to make sure that all modules are
    >really recompiled.
    >
    >Also, ask them to try with the /decompile option.
    >
    >It is normal that there is a change for some of the references in going from
    >A2000 to 2003 but as you don't have A2003, it may be hard to find the error
    >here. Did you try using the Remote Desktop Connection? Might be a good
    >time to start fiddling with it.
    >
    >The message about a possible virus in Access code is a *feature* of A2003
    >(and a real pain in the a** by the way). Your users will have to lower
    >their security setting: Tool | Macro | Security -> Low.
    >
    >(If they have upgraded from a previous version of Access, this option might
    >be missing from the menu, see http://support.microsoft.com/?kbid=833219 for
    >how to solve this.)
     

Share This Page