We help IT Professionals succeed at work.

accees conversion mde to accdb

tesla764
tesla764 asked
on
Does anyone know if there is a way to convert Acccess (mde) format to access (accdb) format?
Comment
Watch Question

President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:

 Nope, but there is a group that offers a service that will re-create the MDB from a MDE.

  It's not an exact duplicate and you'll be missing all your comments, but it will be functionally the same.

Jim.
Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
Jim,

And that group is?

Author

Commented:
How about coverting mde back to mdb?
Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
that's what he said:

"re-create the MDB from a MDE"
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
@tesla764,

   Just to be clear about the question and my comment.

  You have a MDB or ACCDB (Access 2007 latter, which is the new ACE db engine), which contains both source code and "compiled" p-code.

  Then you can have a MDE or ACCDE, which is the same as the above, but the source code is stripped out, leaving just the "compiled" p-code.

  Anything with code in a MDE is therefore un-editable.

  You can yourself though get at any object that does not have code attached to it.  You can also through automation and the saveastext method of the application object also get at form and report objects that have code, but you won't get the code itself.

  No one besides these guys:

http://www.everythingaccess.com/mdeconversion_faqs.htm

 
   Has ever bothered figuring out how to take p-code and get it back to a source code format.  It's technially possible (obviously because they can do it), but extremely difficult to figure out how.

  They actually figured it out for other reasons.  The MDE to MDB service they offer is actually a by-product of other things from what I understand.
 
  Hope that clears things up...

Jim.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
...and a bit more:

Just be aware that your question may straddle the fence of what we can actually answer here.

A developer may create an MDE (or accde) file so that the code is unviewable/unrecoverable.

So for us to tell you how to "Workaround" (Hack, Crack, circumvent, reverse engineer, ...etc) this may be unethical.

In other words, we wave no way of knowing if this is your database (data) or not...

Make sense?

To be sure, ... most "Legit" companies that provide this service will require iron-clad proof that you are the rightful owner of the database (data)

So my first question would be how you came across a MDE file and were not given access to the MBD file that created it...?
...and no way to contact the developer who created it...?

JeffCoachman

Author

Commented:
Thanks.