ActiveX Problem with making MDE file

Posted on 2006-03-29
Last Modified: 2013-12-05
I am trying to run an mde file on a laptop, but Access 97 crashes when opening it.  I've traced it down to a missing ActiveX control.  What the odd thing is, is that there are no references in the mdb file and I cannot find which ActiveX control needs to be registered.  There are no objects in the mdb that require ActiveX.  The development work is done and the mde has been made on another computer.

I also do development in VB and do have other ActiveX controls registered for those apps.  Could this be causing the issue with Access?

Urgent help needed!!!
Question by:Arturus
    LVL 44

    Expert Comment

    by:Leigh Purvis
    How do you know it's an ActiveX control problem - if there are no ActiveX controls in the appliction?
    is it an error akin to "ActiveX component can't create object"?

    Have you checked all your references?
    (DAO especially).
    Re-register them.

    Author Comment

    I moved the mdb to the laptop the mde will be running on and tried to create the mde again.  Error message -

    "There was an error loading an ActiveX control on one of your forms or reports.  Make sure all hte controls that you are using are properly registered.  For information on registerin an ActiveX control, click help."

    The database seems to run fine on the laptop if I run it from the mdb.
    LVL 44

    Accepted Solution

    Ever had an ectiveX control in it?
    There are no references left there though?  Even though the control may have been removed from a form?

    Try the usual, compact/repair, decompiling, re-import.
    Then create your mde again.

    Author Comment

    I took LPurvis's suggestion.  Guess what I found!  A form with an ActiveX control that is not registered.  So I think I can fix this, but I need to konw how to to package the control with the mde file for distribution.  I've never had to do this, what are my options in Access 97?

    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    Typically your installer would provide methods to distribute, install, and register any Activex controls. There are some free installers out there (if you don' thave one): Innosetup is a good one:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now