Conversion to .exe

[Kamron]

I recently finished my Access database (forms, queries,
code and all) and am now trying to distribute it easilly
to some of my colleagues for testing etc.. However not
everyone has Access and I would really like to convert my
database to an exe or make it available to people without
Access. I have Access 2000 and also VB6. Any help would be
greatly appreciated.

Thanks, Kamron.

 

[Douglas J. Steele]

It's not possible to convert an Access application to an executable.

One possibility that exists is to purchase the Office Developer edition,
which gives you a royalty-free run-time version of Access that you can
package along with your application. Users who don't have Access can install
the run-time so that they're able to use your application. Unfortunately,
Microsoft stopped selling the Office 2000 Developer edition quite some time
ago (in fact, now that Office 2003 is out, they no longer sell the Office XP
Developer edition)

You could check out sites that specialize in old software products, such as
http://www.emsps.com/oldtools/ or http://recycledsoftware.com/ or to look at
someplace like eBay to see whether anyone's trying to see their old versions
(Note, though, that products purchased this way aren't always legal...). As
well, under some circumstances Microsoft will downgrade your current version
to a previous version. There are some details about this at
http://www.microsoft.com/PERMISSION/copyrgt/cop-soft.htm#DOWNGRADE

Another option is to rewrite your application in VB, although that
essentially means redoing all of your forms, since there are significant
differences between the controls on forms in Access and those in VB.