How to Create a EXE file for a MS Access Application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a small MSaccess Appliction. Now i want to convert it as a EXE
file. How to do that?
Any body can please help me?....,

thanks in advance,
by
Karthikeyan P
 
It can't be done.

If your intent is to allow users who don't currently have Access installed
to use your application, your options are:

1) Rewrite the application in a language that can be compiled into an
executable (VB, Delphi, Java, .Net, etc.)
2) Rewrite the application as a web application.
3) Package your application with the royalty-free runtime version of Access.

The runtime version of Access is the same msaccess.exe executable that you
used to develop your application, but it's limited in what it can do, due to
literally hundreds of registry entries. It's important that you have the
correct version of the runtime for whatever version of Access you used to
develop the application. Tony Toews has infomation at
http://www.granite.ab.ca/access/developereditionfaq.htm
 
The short answer is you can't! The closest you can come, without a big outlay
of money for a different version of Access (Access Professional, I think) is
to create an .MDE file. This "locks" the application so that end users cannot
make any changes to the structure of the database. Unlike an .EXE file, it
requires that end users have a copy of Access on their PCs.

Go into the code window of a form and goto Debug -- Compile<Your Form Name>

This actually will compile the entire db, not just the current form; if there
are problems that need to be addressed, Access will let you know.

Goto Tools -- Compact and Repair

Goto Tools -- Database Utilities -- Make MDE File

Good Luck!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top