access 97 has option to convert .MDB TO .exe
now i am using Access 2000 and using access run time
please help to find way to convert .MDB to .exe or any other ways

Quote:

---

Originally Posted by Msalam Mohd

access 97 has option to convert .MDB TO .exe
now i am using Access 2000 and using access run time
please help to find way to convert .MDB to .exe or any other ways

---

Sorry no version of Access has ever had an option to convert to an EXE. I don't know what you remember but it doesn't exist. The only way to distribute Access to someone who doesn't have the full version installed is using the Run time version.

What you may be thinking of is converting to MDE. This "compiles" the file so someone cannot get into the forms, reports or modules to make changes.

An mdb must be run with access. There is another way to do it if you are distrubuting to people who do not have access... you supply them with access runtime software. If you buy Microsoft Visual Studio Tools for Office 2003 for newer versions of access, or Microsoft office developer for older versions, you can supply them with the runtime environment. When you take this route you will not be doing anything illegal.. if you supply them with the actual program then it is considered piracy. Microsoft made it hard, but it can be done.

You mentioned that "you can supply them with the runtime environment", how is this done? I have the Microsoft Visual Studio tools, now I'd like to have other computers not running Access, have access to my database.

Thanks in advance.

This is a good article that may help you. http://www.jamiessoftware.tk/articles/runtime.html

Quote:

---

Originally Posted by mazer77

You mentioned that "you can supply them with the runtime environment", how is this done? I have the Microsoft Visual Studio tools, now I'd like to have other computers not running Access, have access to my database.

Thanks in advance.

---

You need the Visual Studio Tools for Microsoft Office. This is an addon that includes development tools including the Access runtime license and a packaging tool for distributing the runtime with your app.

You need Microsoft office 2003 developer edition ,it can make the executabele with no other tools .otherwise you can use the visual studio 2005 with mdb 2000 format , link them with visual basic or c# code ,you will have then to design dialogs that contains the fields ,this will be pretty difficult to office user but to vstudio developer this is a daily job .
Hope this will be helpful !

As noted in my comment, this thread was started FOUR years ago. Please pay more attention to the dates of threads.

Also as noted, the Developer extensions, which are now free in Access 2007, do not create an EXE, they simply allow you to run Access mdb (or accdb) files on a machine that does not have a full Access license.

I do agree, if you want to create an EXE, you need to use a compilable language like the .Net languages that use Visual Studio as a development environment. In that case, you may use Access tables as your back end and create your own front end. I also agree that programming in the .Net languages is way more complex than using Access to create the front end.