Solved

Problem with an mde file

Posted on 2007-11-23
7
1,259 Views
Last Modified: 2013-11-27
Hi

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.

Thanks

The remainder of the error message is as shown in Error 1.
0
Comment
Question by:martmac
  • 3
  • 2
7 Comments
 
LVL 84
Comment Utility
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.
0
 

Author Comment

by:martmac
Comment Utility
None of the refs are marked as missing. That's what's confusing, but if I remove the WebBrowser control the form opens.
0
 
LVL 84
Comment Utility
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?

0
 

Author Comment

by:martmac
Comment Utility
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.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
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.

http://www.experts-exchange.com/OS/Miscellaneous/Q_21846397.html
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 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