How to Make MS Access Database Executable

MS Access is basically a database management system created by Microsoft Corporation. It can be integrated with programming languages to build software applications.

We 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. In this tutorial we will learn about the same concept and will see how we can make an access database as executables.

Step 1 – Making ACCDE File

For that first of all we have to open the access database which we want to make executable.

After that go to database tools on the top and click on make ACCDE.

Database Tools

Step 2 – Saving the Database

After that it will require us to save the ACCDE file, so select the output folder, and click save.

Saving the ACCDE File

Step 3 – Downloading Inno Setup

Once we have ACCDE file, we have to download a setup compiler to make it executable.

In this tutorial we will use and download the latest release of inno setup.

Select the mirror and the download will be started.

Downloading Compiler Script

Step 4 – Inno Setup Wizard

After finishing up with the download, install the software using recommended settings. Once do
ne with installation lets launch the software.

Finishing Setup

Step 5 – Necessary Information

Now click on Create a new script file using script wizard.

Let’s give application name as company database.

The application version as version 1.0 and other basic information like Publisher Information and Company website.

After that, click next

Basic Information

Step 6 – Adding Application Files

Now we will be required to select Application Files, but in our case we don’t have any so let’s choose the 2nd option and Click “Add Files”

Application Files

Step 7 – Locating ACCDE File

Now we have to add our ACCDE file that we just made earlier.

Locating the Database

Step 8 – Completing Wizard

Now after giving the required specification, finish the wizard.

Finalizing the Wizard

Step 9 – Checking the Executable

Once we are done with the creation of our Executable Ms Access Database, let’s check it by installing. We can change the installation folder by clicking browse or can leave it default.

After that Finish the setup.

Database Installation

Step 10 – Checking the result

After installation is finished, lets browse to our installation folder and there we can see our ACCDE file.

Browsing Installed Files

So this is how we can make an access database executable.