Access 2007 to exe

Question

I have a database in ms access 2007 with forms. I need to create a standalone exe file from access. Is it possible? If so, how?

Answer 1

You cannot save it as .exe, but you can use Access Runtime so that users without access can use your application.

Answer 2

If I can just add my two cents ...

You need to allocate Access runtime with your application. I recently heard about Stackoverflow that Microsoft's runtime for access is now free to download.

Here are some links ...

http://www.granite.ab.ca/access/developeredition2007faq.htm
http://blogs.msdn.com/clintcovington/archive/2007/01/30/the-runtime-and-developer-extensions-will-be-free.aspx

You can either distribute these runtimes with your application, or you can download their clients.

EDIT - NEVER FALSE. YOU SHOULD NOT BUY A LICENSE TO PROVIDE PROBLEMS. Of course, they are licensed, but the license is free. I leave a comment below for his historical interest.
I think, but I'm not sure, that in order to extend the access execution time with your application you will have to have a license. I know that you used this license with an MSDN subscription and with Visual Studio Tools for Office.
END FALSEHOOD

Once you have runtime, you can create runtime settings for BULLETPROOF Access applications using pre-configured installation scripts from SageKey.com .

Office developer tools come with some deployment options, but they are not bulletproof, and I will NEVER distribute a commercial application using these ... they just don't work. But the creak of Sagekey is absolutely ROCK. They work incredibly well.

All of this suggests that you want to distribute your application widely. If not (for example ... you just want to deploy your clients and you have full control over this), you can use the Microsoft download option mentioned above.

Last thing. Run-time access applications must be VERY reliable. You should do error handling and automatic table linking very well by the way, or you will spend all the time on the phone with your customers, and not sell / distribute the software.

Hope this helps.

Set

Answer 3

If you have a version of MS Access for developers, you can create a ".mde" file that works just like a .exe file, as far as your user is concerned. Essentially, creating .mde wraps the MS Access executable version with your database.

While you are doing a decent job with your form design, the user really cannot tell your .mde file from .exe.

I have not used the Developer version for several years, but if you recall, it is quite expensive. EDIT (Nowadays he is free).

Below is a link to a good FAQ on this topic. Much more relevance than my memories from the past.

Answer 4

As for the bulletproof versions, yes, Sagekey is the answer. However, another alternative is the Albert Kallal Inno script, which checks to see if Access is installed. If not, it tells you to install the Access version. If installed, it continues to install your FE MDE and other sorted files. http://groups.google.com/group/microsoft.public.access/msg/10e3fc9234660872?hl=en

An example inno script that completes the installation wizard for a package in one .exe http://groups.google.com/group/comp.databases.ms-access/msg/4aa1b33a191bf1f8?hl=en

Deploying your software updates at runtime for Access 2007 http://www.members.shaw.ca/AlbertKallal/RunTime/InstallExample.htm

The only scenario he cannot handle is if the user installs Access or another Access runtime on his system later. However, if you ship your product in Access 2000 format, problems are minimized.

Answer 5

No, It is Immpossible.

Answer 6

I do not believe that this is possible. Sorry to say that. You need Access to run and display the form.