Hello,
I am having problems with a database that I am distributing to users using Access Runtime 2007 and an mde. The mde works fine when I run it on my computer, but some users are getting the following error when the database opens "The expression On Load you entered as the event property setting produces the following error: Class does not support Automation or does not support expected interface". I had never had problems with previous versions of the database distributed as mde, just this latest release.
So far so bad. After a bit of web searching I managed to replicate the error on a computer I hadn't fired up for a while which was running Windows 7 without SP1. As predicted on the internet forum where I found the suggestion, when I installed SP1 the error disappeared and the mde works perfectly. The root of the problem seems to be that I installed SP1 on my PC recently (since the last successful release), and if you make an mde using Windows 7 SP1 you can't run that mde on a PC running base Windows 7 without SP1.
This managed to fix things for most of my users, apart from one who is using XP SP3. Again, I have laid my hands on a computer with XP SP3 which uses runtime to run mde files, and have replicated the error. So far I have established that SP3 is the latest service pack available for XP, and I have tried un-installing SP1 from my 32 bit Windows 7 PC in the hope that I would be able to make an mde successfully as I used to be able to pre-update. Now I can't open the mdb on which the mde is based. I'm just about to reinstall SP1 so that I can at least access my mdb, and am stumped about what to do to fix things for my XP user.
Having my user upgrade his operating system is not an option - he's not an employee of my company, and I want to be able to distribute an mde to any windows user as I used to be able to do before I was fool enough to install Windows 7 SP1.
I would be very grateful for any suggestions.
Best wishes
Dave
[PS This is my first post so I hope I am posting correctly]