By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Getting the forms from one mde to another

mikek12004
100+
P: 200
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?
Jan 11 '10 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,494
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.
Jan 11 '10 #2

mikek12004
100+
P: 200
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"?
Jan 11 '10 #3

NeoPa
Expert Mod 15k+
P: 31,494
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.
Jan 11 '10 #4

mikek12004
100+
P: 200
Indeed in the import object's forms tag I cannot select anything and I have only the mde....is there any other way?
Jan 11 '10 #5

NeoPa
Expert Mod 15k+
P: 31,494
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.
Jan 11 '10 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Jan 11 '10 #7

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 11 '10 #8

Post your reply

Sign in to post your reply or Sign up for a free account.