How to Create a Standalone .exe File

[Chaplain Doug]

Access 2003. I know how to create VBA modules in Access, Excel, Word, etc.
How may I go about writing a VBA module that can be compiled into a
standalone .exe file? Is there a way to do this from Office 2003 without
having to buy something else? By the way, I have the Access developer
extensions. Thanks for the help.

 

[Roger Carlson]

You cannot compile an Access application into a stand-alone EXE. The best
you can do is use the Package & Deployment Wizard to create an installable
package that will put a run-time version of Access onto the user's machine.
You should also convert the MDB file into an MDE file. This just removes the
source code from the application, leaving only the "compiled" code.

To use the Package & Deployment wizard, go into any code Window and choose
Add-in on the Menubar and choose Package & Deployment Wizard.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L