Go Premium for a chance to win a PS4. Enter to Win


Problem with an mde file

Posted on 2007-11-23
Medium Priority
Last Modified: 2013-11-27

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.
Question by:martmac
  • 3
  • 2
LVL 85
ID: 20341281
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.

Author Comment

ID: 20346182
None of the refs are marked as missing. That's what's confusing, but if I remove the WebBrowser control the form opens.
LVL 85
ID: 20347340
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?


Author Comment

ID: 20347416
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.
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 20349147
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.


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

876 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