Can an Access project be made into a stand-alone app?

[Guest]

Is there a way that an Access project (forms, tables, queries, etc.) can be
compiled into a stand-alone executable application?

Thank you.

 

[Brian]

Is there a way that an Access project (forms, tables, queries, etc.) can be
compiled into a stand-alone executable application?

Thank you.

Not exactly. You can create an "executable" version of the file (which will
be either an mde file or an ade file), but it still requires Access to run
it. You can distribute a "run-time only" version of Access so that your
"executable" can be used on computers which don't have Access installed, but
there is a biggish "gotcha", which is that you will need to buy the
developer tools (product name varies according to version of Office/Access).
This costs quite a lot of $$$.

 

[Guest]

I see. Then, I guess I'll have to use VB for the forms and the stand-alone
EXE and just "bring along" the Access MDB's.

Thanks for your insight.

 

[Douglas J. Steele]

Brian may have overstated it. It all depends how many users you're trying to
roll out to. The Access Run-time is available by purchasing Visual Studio
Tools for Office 2003, which according to

http://msdn.microsoft.com/howtobuy/vsto/default.aspx retails for about
$500 US. If you're trying to roll out to, say, 10 users, you're definitely
ahead in terms of cost.

 

[Tony Toews]

Not exactly. You can create an "executable" version of the file (which will
be either an mde file or an ade file), but it still requires Access to run
it. You can distribute a "run-time only" version of Access so that your
"executable" can be used on computers which don't have Access installed, but
there is a biggish "gotcha", which is that you will need to buy the
developer tools (product name varies according to version of Office/Access).
This costs quite a lot of $$$.

Well, yes but given the added costs of developing an app in VB or
another environment compared to Access the runtime isn't that bad.

Also see Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm