Problem with an mde file
Posted on 2007-11-23
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.
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.
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.
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!)
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.