If you have created a database and decide to distribute it or to give it to a customer, colleagues or employees, they may be tempted to open the forms in Design View and possibly modify their structures. There are two disadvantages to such an action. They may compromise or corrupt your hard work, possibly rendering it obsolete. Some bad eye may decide to cheat on your VBA code. Microsoft Access allows you to make some or most of these actions difficult or impossible. An ACCDE file is a database compiled by Microsoft Access so the users of the database cannot change the design of forms or reports, create new forms or reports, view its VBA code, or import forms, reports or VBA code.<\/p>\n
Before creating an ACCDE file, you should enable the security<\/strong>. To do this, on the Message Bar, you can click Options… In the Microsoft Office Security Options dialog box, click the Enable This Content radio button and click OK. To create an ACCDE file of your database, after opening it, on the Ribbon, you can click Database Tools. In the Database Tools section, you can click Make ACCDE. You will receive the Save As dialog box with a suggested file. You can accept that file name or replace it. After this, you can click Save.<\/p>\n MS Access is basically a database management system created by Microsoft Corporation. It can be integrated with programming languages to build software applications. Follow this easy step by step tutorial to learn how to make an Microsoft Access database executable by Inno setup<\/strong>.<\/p>\n Step 1 – Making ACCDE File<\/strong><\/p>\n For that first of all we have to open the access database which we want to make executable.\u00a0 After that go to database tools on the top and click on make ACCDE.<\/p>\n Step 2 – Saving the Database<\/strong><\/span><\/p>\n After that it will require us to save the ACCDE file, so select the output folder, and click save.<\/p>\n
\nWe can also create our database as executables so that one will not worry about copying all the folder and files rather it would become just a simple installation suite.<\/p>\n