Microsoft Access - accde revert to mdb

Asked By farrukh on 07-Aug-11 11:13 AM
Dear All,

I have .accde and i want to uncompile or revert to .mdb for edit purpose how can i do this?

Thanks
hameed 
Radhika roy replied to farrukh on 07-Aug-11 12:57 PM
  • .accde  This is the file name extension for Office Access 2007 files that are compiled into an "execute only" file. This format takes the place of the .mde file name extension that is used in earlier versions of Access.

An .accde file is a "locked-down" version of the original .accdb file. If the .accdb file contains any Visual Basic for Applications (VBA) code, only the compiled code is included in the .accde file. As a result, the VBA code cannot be viewed or modified by the user. Also, users working with .accde files cannot make design changes to forms or reports. You create .accde files from .accdb files by doing the following:

  1. In Office Access 2007, open the database that you want to save as an .accde file.
  2. On the Database Tools tab, in the Database Tools group, click Make ACCDE. Button image
  1. In the Save As dialog box, browse to the folder in which you want to save the file, type a name for the file in the File name box, and then click Save.

split the database

then convert the database with the tables in it!

Just ran into the A2007 ACCDB database format for the first time (I'm using 2003 & 97). After an extensive search, have yet to find a solution to convert the new format to a previous MDB version (without using A2007). 



visit these site

farrukh replied to Radhika roy on 07-Aug-11 01:13 PM
Hi Radika ray,

Thanks a lot for your admirable reply, i got the valueable information about .accde. Is there any way to view the vba codes i want to edit some code in it?

Thanks
hammed
Irfan Khan replied to farrukh on 07-Aug-11 02:59 PM

If the file is another person created then there I think must be putted security by him, if your created file and you not know that how to put VBA code in it, open the file in MsAcess, go to Database Tools menu in MsAcess 2010 suppose, and click Visual basic icon there or shortcut(Alt+F11).

farrukh replied to Radhika roy on 07-Aug-11 03:16 PM
Radihka ray and Irfan,

I got it, thanks alot and appreciate radika your information about .accde extention.

Thank you irfan khan :)
Irfan Khan replied to farrukh on 07-Aug-11 07:23 PM

You are welcome.

“The life of a man consists not in seeing visions and in dreaming dreams, but in active charity and in willing service”

Jitendra Faye replied to farrukh on 08-Aug-11 12:51 AM

Microsoft Access database applications are normally planned, designed and built using the standard single file format in either .MDB or the newer .ACCDB (Access 2007/2010) and then distributed with all the objects (Tables, Queries, Forms, Reports, Macros and Modules -VBA code) fully accessible with the standard default settings applied.

To help lock down and prevent certain objects especially Forms, Reports and any code being modified (via the design mode), you can convert your database file into an ‘executable‘ file format where the .MDB becomes a copy as an .MDE and the .ACCDB to a .ACCDE.

Follow these link-
http://accessdatabasetutorial.com/2011/02/07/converting-a-microsoft-access-database-file-to-a-mde-file-or-accde-file/

Here you will get future steps.

Hope this will help you.

farrukh replied to Jitendra Faye on 09-Aug-11 02:08 PM
Hi Vickey F,

Thank  you :)
Pat Hartman replied to farrukh on 10-Aug-11 12:58 PM
I read all the answers you got and people gave you a lot of information but no one ever answered the question.  The answer is - you cannot go back.  It is IMPERATIVE that you keep the original .mdb or .accdb when you create an .mde or .accde because you will need to make all changes to the original database and then recreate the .mde or .accde.

If you can prove that you own the database, there are services (expensive) that will take the compiled database and generate an .mdb or .accdb from it but don't expect the code to look anything like the original.  It will be almost unreadable because all the original variable names, formatting, and comments will be gone.  Since they are not included in the compiled p-code there is no way to "decompile" them.
Jitendra Faye replied to farrukh on 12-Aug-11 10:01 AM
You always welcome.