General discussion

Locked

How do I open an *.mde file in Access 20

By bill ·
I am trying to open a mde file that was sent to me and when I try to open it I get a window that asks if I want to convert or open the database.

If I choose convert it tells me I can not convert or enable a mde file. I get the same thing if I choose open.

I was under the impression that a mde file is simply the data with code removed. This is fine all I want is the data.

Is there a way for me to open this file?

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How do I open an *.mde file in Access 20

by SyscoKid In reply to How do I open an *.mde fi ...

.mdb is a data file. .mde is a compiled data file (i.e., with the code modules). Was it made in Access 97? I have heard modules compiled in Access 97 will not run in Access 2000. Our organization had to rewrite all Access 97 .mde's to run in 2000.

Trry holding down the shift key and double-clicking on the file. That bypasses any attempt to run the code, and gets you right into the database.

Collapse -

How do I open an *.mde file in Access 20

by bill In reply to How do I open an *.mde fi ...

It was done in 97. It did let me import the tables though so I did get to see the data. Thanks

Collapse -

How do I open an *.mde file in Access 20

by Joseph Moore In reply to How do I open an *.mde fi ...

Technet article Q216163, "ACC2000: Can't Open or Convert Access 97 MDE in Access 2000" states the following:

Symptoms
When you use Microsoft Access 2000 to open or convert an MDE file created with Microsoft Access 97, you may receive the following error message:

You can't convert or enable an MDE file.
Cause
An MDE file is a database in which all Visual Basic modules are stored in a compiled state and from which the source code has been removed. Because the source code has been removed, you cannot edit the design of forms, reports, or modules in an MDE database.
Resolution
Convert the original Microsoft Access 97 database to a Microsoft Access 2000 database. Then create an Access 2000 MDE file from the converted MDB file.
More Information
Microsoft Access 2000 uses a different method for storing a database's Visual Basic for Applications project than was used in earlier versions. In order to use databases created in earlier versions of Microsoft Access, the database'sVisual Basic for Applications project must be converted or enabled in Microsoft Access 2000. However, because the source code for an MDE file has been removed, and because an MDE file cannot lose its compiled state, Microsoft Access 2000 cannot convert or enable the database.

Collapse -

How do I open an *.mde file in Access 20

by Joseph Moore In reply to How do I open an *.mde fi ...

So, you will have to contact the person who sent you the MDE file, and have them either send you the Access97 MDB file for you to convert to 2000 and THEN make an MDE for you to use, or the database author can do this.
Sorry for the not good news.

Collapse -

How do I open an *.mde file in Access 20

by bill In reply to How do I open an *.mde fi ...

It was done in 97. It did let me inport the tables though so I did get to see the data. Thanks Had a hard enough time getting this data from the person. Wish me luck.

Collapse -

How do I open an *.mde file in Access 20

by john_wills In reply to How do I open an *.mde fi ...

Don't bother trying to open your mde file, or looking at the old mdb file. Create a new mdb file and in the tables part of the database window do ALT/F/Get External Data/Import. You will be given an explorer with which you can address your mde file.You will be shown its tables, and you can highlight them and press the button to import them to your mdb file. This should work as long as the mde file is in at least as old a version of Access as that you are importing into.

Collapse -

How do I open an *.mde file in Access 20

by bill In reply to How do I open an *.mde fi ...

Poster rated this answer

Collapse -

How do I open an *.mde file in Access 20

by RichTee In reply to How do I open an *.mde fi ...

The answer to your question is: No.

The first part of Anwer 1 is correct. You can not use Access2K to open an .mde database created with Access97. The following excerpt is take from MS KB article Q216163.
Symptoms
When you use Microsoft Access2000 to open or convert an MDE file created with Microsoft Access 97, you may receive the following error message:
'You can't convert or enable an MDE file. '
Cause
An MDE file is a database in which all Visual Basic modules are stored in a compiled state and from which the source code has been removed. Because the source code has been removed, you cannot edit the design of forms, reports, or modules in an MDE database.
Resolution
Convert the original Microsoft Access 97 database to a Microsoft Access 2000 database. Then create an Access 2000 MDE file from the converted MDB file.

As can be seen, unless you can get to the original database and convert it first to Access2K and then create the .mde, you will have to use Access 97 to use the database.

Good Luck, Rich

Collapse -

How do I open an *.mde file in Access 20

by bill In reply to How do I open an *.mde fi ...

Poster rated this answer

Collapse -

How do I open an *.mde file in Access 20

by bill In reply to How do I open an *.mde fi ...

This question was closed by the author

Back to Software Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums