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?
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"?
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 :
Open the database you want the form to be added to.
Select (My instructions are for Access 2003 - I don't use 2007.) File / Get External Data / Import... from the menu.
Select the Access database MDB file using the browser.
Select the Forms tab.
Select the form (or all the forms you want imported).
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.
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.
