You cannot create an EXE, but you can create an MDE which has is a sort of pseudo compiled version. KEEP A COPY OF YOUR .mdb since you cannot amend forms, code etc in an MDE
You can also use the runtime version of Access which allows users who do not have Access installed on their PC to run your application Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -
You can not create an .exe file out of a database. The best you can do is an .mde file. In A2K or higher you would go to Tools/Database Utilities/Create MDE (I'm not sure about the last command but you will see the one you want). In A97 the command was in the File menu. The MDE file will have all of the code compiled and the user will not be able to go into design view (error trapping is extremely important if you want to use this type of file). An MDE is not a stand alone application though. The user will need Access or Access Runtime to use the application.
I don't know for what purpose you want to create a EXE, but you can also create a .BAT...with a Autorun command...
Like :
N:\Applications\MyDatabase.mdb /cmd Autorun
--------------------------------
LongStar
"If everything seems to be going
well, you obviously don't know what
the hell is going on !" (Murphy)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.