ActiveX Problem with making MDE file

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!!!
ArturusAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leigh PurvisDatabase DeveloperCommented:
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.
0
ArturusAuthor 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.
0
Leigh PurvisDatabase DeveloperCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ArturusAuthor 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?

0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.