We help IT Professionals succeed at work.

ActiveX Problem with making MDE file

Arturus
Arturus asked
on
Medium Priority
459 Views
Last Modified: 2013-12-05
Hello,
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!!!
Comment
Watch Question

Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
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

Commented:
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.
Database Developer
CERTIFIED EXPERT
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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?

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
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: http://www.jrsoftware.org/isinfo.php
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.