Compiling the MS Access DB

rehanemis

Registered User.
Local time
Today, 17:35
Joined
Apr 7, 2014
Messages
195
Hi,

I have created an database in ms access. I would like to compile it into stand alone program so that users can use it without installing the ms access and they also can't modify the program.

Looking forward for efficient solution.

Thanks
 
Your options will be limited. Which version of Access are you using?
 
I am Using MS Access 2013 Version.
 
Okay. On the ribbon, I believe in database tools/database utilities(I'm doing this from memory, as I only have 2003 at work), there should be an option to create an ACCDE file, which is more or less a fully compiled file.

DO NOT DELETE YOUR ACCDB - YOU STILL NEED IT FOR FUTURE CHANGES/UPDATES!

Once you have the ACCDE, rename it so the file extension is ACCDR. This will tell Access itself to operate in run-time mode when running this file, but it ALSO makes the file executable by someone who lacks an access install but has installed the (free) Access 2013 Runtime extension from MicroSoft.

That's about as close as you're going to get to a stand-alone with Access, I'm afraid.
 
What i am looking is that what i have seen in an organization. They have Stand alone version of ms access DB without having ms access or run time.

I am looking for that type of version. They might have used third party software to make it stand alone.

I am not sure but still looking for software that makes it stand alone.

Thanks
 
Trust me, unless you're dealing in copyright-infringing software, that doesn't happen. You need at least the runtime.

Good luck.
 
Thats Good.

Please tell me about copyright-infringing software's so that i can purchase them and can use them.

Thanks
 
Out of curiosity, which part of 'not going to happen' did you fail to understand?

If you want to distribute a self-executing database application, write it in a language that doesn't require proprietary software to run. I'd suggest VB or C++.
 
To reiterate what Frothingslosh has said, there is no way to make an Access file into an executable front end; it requires either the full or runtime version of Access. The runtime version is free from Microsoft. The organization you saw had probably done what was suggested in post 8, and Access was just used to store the data.
 

Users who are viewing this thread

Back
Top Bottom