Making a database an .EXE

[spencern]

Hi,
I'm thinking of starting a small database project for someone who doesn't have a version of Access on their computer. Once I'm done with the database is there anyway I can turn the .mdb into an exe that will let data be entered, but won't let the forms be edited?

Do I need the Developer version of Access to do this, or is there any other cheaper program that would do the job?

Thanks for your help,
Spencer

 

[hermanlaksko]

Hi Spencer

You can not make an mdb file into an exe file but if you are running access ver. 97 the developer edition of this program will let you create a run-time version of your program.
If however you are running A2K or A XL it is an entirely new ball game: contact

http://www.wise.com/download.asp

here you will find programs that will help you setup an access run-time, however you start from scratch :-( to get a jump start you should contact:

http://www.sagekey.com/

however these boys do not let you download any eval. copy.
Let me know what you decide and if you go for this and are having problems maby I can help you off-line.

Rgds Herman

 

[oharab]

There are developpers editions of A2k and A2k2 available that will create runtime files. The A97 version is now very hard to get hold of & not for sale from M$.
The sites Herman mentioned will not turn your mdb into an exe (as this is just not possible) nor will they turn your mdb into a runtime version. What they do is take your runtime package (as created by the deployment wizard in the developers edition) and create installation scripts that make them easier to install.
If all you want is to protect your code, you can turn your mdb into an mde file. This compiles all the forms and modules and makes them so they can't be edited. A user will still need to have Access on their machine to run the file, but they won't be able to view or edit your code.

Good luck in whatever you are trying to do.

B ----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[thornmastr]

Nope. Won't work.

If you need an exe develop in some other language.

You will need a copy of the Access run time files to run and mdb without Access. The only way to do this legally is by using the Developers Edition of Access.

Sagekey provides scripts; not Access executables. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[hermanlaksko]

Sry to say this boys, but the Wise/Sagekey solution works as I have used it on several occations, and allthoug trickey it does work, but enough on this.

I do not think that M$ hav any rights to programs that one develops in Access, on this I am quite sure.

The run time unit is indeed on the Developers CD/DVD but this can also be d/l on the net.
One does not have to own a developers edition of access if one wants the runtime set this can be d/l on:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q243957

Rgds
Herman

 

[hermanlaksko]

Looks like I was too fast on my trigger on the d/l-developers CD. Sry.
Opon reading further in this article it is clearly stated that one does have to own a developers edition to d/l the runtime.

However it seems odd to me that one would want to d/l the runtime from M$, when this is found on the CD!!! allthough I realize that the net is updated and the CD is not.

But the SR-1 is not available for d/l and is only available in CD form, what one gets on the net is the old version, in other words your CD is better than whats is on the net, if you own a SR-1, if you own a standard dev.ed. you have this version on your CD so whey d/l. Well I guess its M$ logic.

Herman