Let me remark this shows the risk of losing the source of any application. That's rather unprofessional.
http://technet.microsoft.com/en-us/library/cc178973%28office.12%29.aspx states (among a lot of other useful things):
MDE file limitations
MDE files are MDB files that have VBA source code compiled into computer
code and VBA source code removed. Office Access 2007 cannot convert or enable
an MDE file. To upgrade an MDE file, you must find the original MDB file and
convert that file.
It's amazing it works in Office 2010 again, but I have to believe you if you say so.
It seems you have the choice of:
a. Program it again in a current version of MS Access.
b. Providing your client with Office 2010 to run that application.
c. Have your client upgrade to Windows 7 Professional or Ultimate, install the virtual XP and run that mde-file in that virtual machine.
Best of luck. And let's hope your posts in a multitude of other forums have more success than this one.
Kees
Hello.
I build an application for a client in Access97 and gave them the MDE version which includes the Access97-runtime (because they have an Office (2007) version without Access).
When they try to open the MDE-file, the get the error:
"You can not convert or activate a MDE file" (my translation of the original error, in Dutch:
"U **** een MDE bestand niet converteren of activeren.")
When I tried to install it on a PC with Office-2010 Starter Ed. (which is without Access), it worked fine.
Could anyone explain me what is the reason for the error, and how to solve it? By the way: I can not convert the application from Access97 to a newer version (like Acces2007),because I only have the Access97-runtime, and because the client doesn't have Access, I have to include it in my installer-file.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic