Hello,

I have a A2003 application that I am making some minor changes to and fixing and trying to find the issue where the installed package won't run on a Win7 PC.

When I ran through the Custom Startup Wizard, and pressed finish at the end, an error displayed regarding one of my forms: "Class does not support automation and does not support expected interface".

I went to open the application in development mode and am now getting the following error:

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


I have checked and rechecked and triple checked my references. There are no missing ones listed. All my regular modules have public subroutines or functions.

I am not sure where to look, what to look for or how to resolve this

My PC that I am working on currently has Access 2003 and Access 2007 on it, but I am working in A2003 only. The Devleopers Extension version I am using is 2003. My PC is Win7.

Please let me know what other information you may need. I feel helpless being this clueless.

Many thanks in advance for any assistance, direction or ideas.

Debra

I don't know if this will help,

I grabbed a old backup of this application to start again with thinking I did something in the application and this one gets the same error. So that makes me think that I did something to either the system files or pointers or something when starting up the Custom Startup Wizard?

Debra

Debra.

First thing I would check out:

1) Does you Dev PC that you are using to create the installer package have the SP1 update for Windows 7 installed?
2) If yes, goes the target Windows 7 PC not have the SP1 update installed?

There is a known issue with backward compatibility with Windows 7 SP1 to Windows 7 without he SP1 update.

TIP: Starting with Vista the Program files folders are read-only. I would avoid placing your Access databases in the program files folder.


FWIW:
For Access 2003 applications I create the MDE and create the installer packages under Windows XP OS. I use XP mode on Windows 7 64 bit to run Office 2003. Access 2007 is installed on the host Windows 7 OS. This avoids any side-by-side (multiple version) issues on the same Windows installation. It also avoid the Windows 7 SP1 issues.

Note: XP mode is include (free XP license) with Windows 7 Pro or higher.

Thank you HiTechCoach for the great information. I'll be taking a look at those suggestions.

My immediate problem however is that since trying to package the MDE and getting the "Class does not support automation and does not support expected interface" error, I cannot run the application at all now, even in development mode. Do I need to uninstall the Developer Extensions?

My Win7 PC is the Home Premium version, so I don't have the XP mode to use. I do have an XP machine, so I will try and work on that one if I can.

Thanks again.

Does the MDB work correctly on your XP machione?

A missing reference can cause lots of other VBA code with valid references to generate errors. Did you resolve he reference issue?

Have you tried to /decompile the database?

If the /decomplie does not work, try creating a blank new databases and importing in all the objects. You will also need to reset the VBA references.



You can run Virtual PC (free download) on your machine. You can Install XP. You will have to have a valid license for XP to install it (just like on any computer). This is included in the price with the Win 7 Pro and higher versions.

Yes the MDB works on the XP machine, so I'm making my changes there.

I have not been able to resolve missing references because there is nothing listed as missing and the ones that I have checked are pointing to valid files. I don't know how else to check for missing references.

I have never done a /decompile before. I will look it up and give that a try. This makes me think that maybe this database is corrupted?

Thanks for all your help and ideas!

Ok, the /decompile did not work, nor did creating a new db and importing the objects back in. Same error message when I try to open any form. It is just happening on my Win7 PC which it used to work on (as recently as yesterday).

Any other ideas?

Thanks!

It sounds like it is an issue with the Office install than the Developer Extensions.


On the Wind 7 PC:
Does it have SP1 for Windows 7 installed?
What service pack (SP) level do you have installed for Office/Access 2003?

In Access 2003: On the Help menu, have you tried Detect and Repair?

Click to view attachment


EDIT: Corrected menu name. included screenshot

I have WIN7 SP1
Access 2003 (11.5614.5606)
I'm not seeing any SP for Access 2003

I don't see a Detect and Repair on the Tools menu. I have a Compact and Repair Database which I've tried several times.

Office 2003 has three Service Packs. Mine shows Access 2003 (11.8321.8341) SP3. May need to install SP3 on all the machines to get everything current and the same.

Sorry. The Detect and Repair for Access is on the Help menu. This has been able to fix issues for me on some PCs. I updated my previous reply to include a screenshot.

Thank you for all the great info.

I will get with my user and we will make sure we have Access 2003 SP3 on all PCs.

I am at work now, but tonight I will check out the Detect and Repair on my WIN7 PC and see if that helps. Also I will put SP3 on both PCs.

I'll let you know.

Thanks again

Thanks for the update.

Thank you Boyd!

I am happy to report that after applying SP3 to my Win7 machine, the database is working once again.

Also we packaged the mde to install NOT in "Program Files" and that problem seems to be resolved now.

I think we are on our way to getting this version out the door (finally) - thanks again!!

Debra

Debra,

You're welcome.

Glad to hear that you are back on track. Good luck with your project.