Getting the forms from one mde to another

[mikek12004]

Have an mde file with lots of tables/forms which became kinda corrupted. With a restoration utility created a 'repaired version' with all tables but it didn't transfer the forms, how to transfer them?

[NeoPa]

You need to import them from the original MDB file. This is always the case when working on the design. An MDE is essentially R/O design.

[mikek12004]

You need to import them from the original MDB file

how do you do it? (both damaged and repaired are in Access 97, rarely use access so some pointers would be most helpful )
what do you mean by "R/O design"?

[NeoPa]

I'm sorry. I meant the MDE is Read Only as far as the design is concerned. I should also have said that you cannot extract the design from it (which I'm fairly confident is true though I don't have one here, so cannot test conclusively).

To extract a form from one database and use the duplicate in another, do :

1. Open the database you want the form to be added to.
2. Select (My instructions are for Access 2003 - I don't use 2007.) File / Get External Data / Import... from the menu.
3. Select the Access database MDB file using the browser.
4. Select the Forms tab.
5. Select the form (or all the forms you want imported).
6. Click OK.

[mikek12004]

Indeed in the import object's forms tag I cannot select anything and I have only the mde....is there any other way?

[NeoPa]

I'm not clear what you're asking here as you have been so brief and imprecise. It seems you're asking questions I've already answered, but I can't be sure. Please be clearer about what you're asking and what you're referring to.

[MMcCarthy]

mike

If you are saying you only have the mde file and that there is no mdb file then you have a problem as NeoPa has said you cannot extract the forms from an mde file. It is a read only file.

You need to track down the original mdb file whether it is on your computer/server or with the original designer of the database. An mde file is only an executable version of the application. The forms, queries, code, etc are just not available to you.

[nico5038]

There are some companies offering mde to mdb conversion, however I'm not sure about the quality and it will cost $$'s.
E.g. see http://www.everythingaccess.com/mdeconversion.htm

Nic;o)