Making Access 97 database executable (.EXE)???

[mark01]

I've heard of a program that will take the database (forms, tables, etc) that you've made in Microsoft Access and make it into an executable, so that you don't have to have access to run it.

Where do I get this program??? Is it something like Access Developers Kit or something???

Thanks

 

[WildHare]

No such beast, so far as I know. The closest you'll get is the ability to create an "MDE" file, which is a compiled and "unchangeable" version of your MDB file. Supposedly runs a bit faster and is a bit leaner. But users will still need Access.

However, an app built with Visual Basic and using the JET db engine, I BELIEVE, can be compiled in to an executable. The VB experts here can verify or deny that assumption.

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[WildHare]

..and another thing - I don't remember if MDE capability was included in A97 or if it came out with A2K...sorry...

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[richieuk]

You cannot make an exe from an mdb in access. The ODE only adds the runtime files required for access, which from A2k on is approx 160-180meg. There are third party utilities around which purport to convert an mdb to a vb application but with varying degrees of success, apparently.

 

[allanon2]

Access 97 has mde capabilitiy. You are correct in stating that vb will compile to an exe which can then be used against an access back end.