Microsoft Access Database: How to Make MS Access Database Executable
This is not the first time I’ve discussed how to make MS Access database executable by converting it into either a MDE or ACCDE file format but some of the power users and developers are unaware of a couple of other post steps that should follow.
Check out the quick two and half minute video on the first step and then watch step then second by locating a third party vendor’s free software application to create that all important script file.
So, you can see how easy it is to generate a run-time version and strip out the design components. There are a few things to also bear in mind…
Microsoft Access Database: How to Make MS Access Database Executable – Few Pointers
Make sure you include the version’s free run-time application as a file in the script which is free so don’t pay for it. This will normally be required if the end user does not have MS Access installed on their computer which this is a freely available to install and use.
You may want to also add a text file or two with some release notes and general update information to help end-users to first install the run-time and know about support resources plus any general functionality changes if this were an update release.
It’s therefore important to have version control and number them accordingly. Any major release will normally start with 1.x, 2.x and a minor patch update may use 1.1, 1.2, 2.1, 2.2 etc.
Also, include any external files that will support your database file namely icons and image files which is normal for any polished looking and functional database application.
I would also suggest that you test your new script out before distributing your application but the challenge here is of course is that you already have Microsoft Access (full open version) installed. I tend to use an image like VMWare to run an empty Windows instance and then re-instate it for each new test.
So this is how to make an MS Access database executable – there are other alternative vendors too so browse around and see what fits best.