how to make an executable in MS Access

[dgillz]

I have a nice neat litlle MS Access update quesry based on some linked tables from an ODBC datasource and a parameter field. Works great.

How do I make an executeable of this? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[JoaoTL]

See javascriptpenindex(450,350,'

http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=350')

Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[JoaoTL]

Sorry

See

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/27/pid/181/fid/1074

Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[dgillz]

That link is not working, it took me to the tek-tips main page. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[JoaoTL]

See FAQ - faq181-1074 Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[Francescina]

The answer is simple: You can not transform a MDB file into an .exe.

Here an article from the ACCESS ONLINE ENCYCLOPEDIA (

http://www.unsoftwareag.com

)

Article Code: D1

Runtime issues: an overview
Transforming MDB files into EXE files

It is definitely not possible to transform a MDB- or MDE-file into an executable file since the MDB and MDE-files contain dynamic data such as tables.
The runtime version of Access can open any MDB and MDE file. It is (nearly) identical with the full version except that the database window is inaccessible, database objects can only be created and modified by code and you need a navigation system that is based on forms.
Furthermore, some functions are not available in the Runtime version such as the "Filter by Form" feature.
The runtime version is sold in the so-called "Developer Edition" and its license agreement allows ACCESS developers to distribute it freely with their custom applications.
Upgrading issues: A97 Developer Edition vs MOD-2000


The MS Access 97 Developer Edition is no longer on sale. You might find a "used" copy, but it is quite difficult because of the MS licence agreements: mainly purchased by professional Access developers, the A2K-Developer-Update-licence REPLACES (!) the A97-licence.
Update purchasers are not allowed to sell their A97-Developer-Edition and most are not interested since they often have customers with A97-applications still running.


Necessary disk space

The runtime files occupy more than 150 MB of disk space (since IE5 is included and installed automatically, these files can not be suppressed).
Consequently, you need to distribute your application on CD-ROM. There is a patch (minimal version) available at the MS download center that reduces the necessary disk space to 70 MB (IE 5 is replaced by IE 3.4), but even if you use the minimal version CD-ROM deployment is inevitable. Furthermore, the minimized version lacks several functions.

The Package and Deployment Wizard

All ACCESS applications require a certain number of files. The minimum case scenario is one single MDB or MDE file, but in general applications are more complex: activated security systems require MDW files and startup shortcuts, language or training versions work with several backend files, special folder structures are necessary as well as fonts, icon files, shortcuts, ActiveX elements, wizards, CHM files, sound and graphic files...
The complete folder and file structure needs to be managed by a special installer program. MS delivers the so-called "Package and Deployment Wizard" aka PDW with the Developer Edition.
Unfortunately, the PDW is not very confortable to work with, its functions are limited and it is extremely inflexible.
Even its activation is tricky:
After the installation of the PDW on your hard disk you will not find it in ACCESS' list of add-ons! You first need to open the VB-Editor window and activate the PDW.
The reason is the fact that the PDW has not been designed for ACCESS 2000 but for Visual Basic 6! This explains why a part of the functions that do not work with the deployment of applications (no shortcuts or ICO-Files, often the keyboard-language changes automatically from non-english languages like Danish and Dutch to English and so on.
Lots of professional ACCESS developers replace the PDW a more performant installer. You will find the MDT-2000 installer on our PowerUps! page. MDT-2000 is the only installer on the market that has been designed specifically for ACCESS 2000.