Problem with an mde file


I truly hope someone can help me with this one. I have spent hours trying to diagnose what the problem is without success and am desparate for a steer.

I am having a major issue with a distributed app where the mde file is producing a mass of errors.

I have an acceess 2003 app that I have developed which contains a number of 3rd party Activex controls. As an mbd file on the development PC it works fine as would be expected. I can create an mde file without issue and the mde file also compiles and runs fine. I then produced a package using the QSetup App and tried an install on a further PC and once again the app runs fine with no errors.

Thinking all was well I sent a test package to the client to install on his PC and the app failed to open producing an OnCurrent Error message that indicates there is a reference missing. Not unusual I thought and started to look at the references to check they are all OK. None were showing a missing, so I checked service packs with the client etc and all appeared well. Telling the client I would get back to him, I went to my Trusty VMWare and used a basic Virtual PC WinXP install with Office Pro 2003 with all the service pack update etc.

I ran the package on that and the same errors occured. My initial thoughts was that one of the ActiveX components was not registering properly, so I created a series of test forms each with one of the components, so I could test if the forms would open OK. - No problem each form within the mde opens with the component appearing and operating fine.

The opening form was generating an OnCurrent error, so in an effort to see if the form would open, I recompiled the form and removed the code from OnCurrent. Alas the error continues to appear and I am also now getting some even stranger errors as listed below.

Error 1.

The Expression On Current you entered as the event property setting produced the following error:
You cancelled the previous operation. (I didn't cancel anything by the way)

* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure],
* There may have been an error evaluating the function, event or Macro.

Show help reveals

Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base article 283806.
An Expression is misspelled.
Check all expressions used in event properties for correct spelling.
A user-defined function is declared as a sub or as a private function in a module.
Expressions can resolve a user-defined function only if the function is declared as one of the following:
A public function in a module
A public or private function in a code module of the current form or report
Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.

Error 2.

The expression StatusTextChange you entered as the event property setting produced the following error: Object or class does not support the set of events.

The remainder of the error message is as shown in Error1.

Error 3.

The expression SetScureLockIcon you entered as the event property setting produced the following error: Object or class does not support the set of events. (I have not th slightest clue what this refers to at all!)

Error 4.

The expression SetPhishingFilterStatus you entered as the event property setting produced the following error: Object or class does not support the set of events. (Again I have not the slightest clue what this is)

And the errors go on and on and then the form opens. But as soon as the mouse is moved over any form button I get an OnMouseMove Error.

Having written this down, I am wondering if the problem relates to the Microsoft WebBrowser Control used on the form? Might this have something to do with IE7 running on the PC. I ma totally confused and would be happy to part with as many points as is required given I have to get a fix for the problem yesterday!

Any help would be very much apprecited.


The remainder of the error message is as shown in Error 1.
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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you list all references you currently have in the trouble app?

In your vmWare - can you transfer the .mdb file to that virtual machine and try to open that file, then examine the refs and see if one is marked "Missing"?

FWIW: I've used the WebBrowser control in a distributed app with users running various versions of IE and had no trouble. That doesn't mean you won't have trouble, of course.
martmacAuthor Commented:
None of the refs are marked as missing. That's what's confusing, but if I remove the WebBrowser control the form opens.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What version of IE is installed on your vmWare instance? If you upgrade the IE on the vmWare instance, do the errors go away?

Did you check the refs on vmWare instance, and not on your dev machine?

martmacAuthor Commented:
Using IE7 this is both on the dev PC and on the VMWare PC. Also the refs I checked were on the VMWare PC. I am wondering if the VB6 runtime is not on the VMWare PC.

When I check the refs in terms of tracing the Webbrowser Control dll it refers to iframe.dll/1 which is strange.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The VB6 runtime is installed along with XP Pro/Home, so it's there. Have you insured that you have a file named iframe.dll (or it might be ieframe.dll)?

Have you performed a full virus/malware scan lately?

Could this be related to settings in IE7? If I recall, the settings for IE7 tended to be much more restrictive.

Finally, one question here on EE refers to something similar, and the fix was to "copy ieframe.dll from the IE7 installation file into /system32/". Perhaps you could try this.

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
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.