Open MDE file access 97 to access 2002or 2002

[Bassem Fahmy]

Hello,

I have a friend all his work in MDE file using access 97..

After he upgrade to access 2000 the file do not want to open and says "You
can`t convert or enable an MDE file".

So i would like please someone to explain to me clearly to non expert in
access on how to convert this MDE file to can work in access 2000 or access
2003

Best Regards,
Bassem
(e-mail address removed)

 

[Dirtblack]

test

 

[John Vinson]

So i would like please someone to explain to me clearly to non expert in
access on how to convert this MDE file to can work in access 2000 or access
2003

It cannot be done.

A .mde file has all of the VBA source code REMOVED. It is gone; it
cannot be recovered or reconstructed. Therefore the database cannot be
converted to 2000 format.

The friend must find the .MDB file which was used to create the .MDE,
convert *that* file, and then create a new .MDE. If the .MDB file was
not kept, they're out of luck.

John W. Vinson[MVP]

 

[tina]

hi John. i don't have an A97 mde file to test, so i'm just curious: in this
situation, can native data tables be imported from the mde file into an
A2000 db? also, to back up a step, i was thinking A2000 would run an A97
mde - just not allow any design changes to tables, queries, macros; it's
been several years since i dealt with an A97 to A2000 issue - am i
remembering it wrong? tia, tina

 

[Rick Brandt]

hi John. i don't have an A97 mde file to test, so i'm just curious:
in this situation, can native data tables be imported from the mde
file into an A2000 db? also, to back up a step, i was thinking A2000
would run an A97 mde - just not allow any design changes to tables,
queries, macros; it's been several years since i dealt with an A97 to
A2000 issue - am i remembering it wrong? tia, tina

Yes, you can import the tables and queries. No, Access 2K cannot run (at all)
an Access 97 MDE.

 

[tina]

thanks Rick

Yes, you can import the tables and queries. No, Access 2K cannot run (at all)
an Access 97 MDE.

 

[Bassem Fahmy]

Thanks all ..

Bassem

thanks Rick


(at

 

[Guest]

Just to add on what Rick wrote, you can import also macros.