Convert Access File to exe?

E

Ed Hawley

This is likely a dumb question but I have created a working file in Access
that I would like to provide to some of my clients for there use in tracking
their stock investments. Is there a way to complile this file and make it a
stand alone file since not all of my clients have Access?

Thanks!
Ed Hawley
 
R

Ron Hinds

Ed Hawley said:
This is likely a dumb question but I have created a working file in Access
that I would like to provide to some of my clients for there use in
tracking their stock investments. Is there a way to complile this file and
make it a stand alone file since not all of my clients have Access?

Thanks!
Ed Hawley
Click to expand...

Yes, but not a .EXE. You compile your project to a .MDE (Tools | Database
Utilities | Make MDE). It is wise to first split your app so that the tables
(data) exist in the back-end database, which you do *not* compile. If you
have Office Professional, it comes with a royalty-free Access Runtime that
you can distribute with your app. Search the Office Professional CD - I
think it is in a folder called Runtime but search for accessrt and you will
find it.
 
J

John W. Vinson

If you
have Office Professional, it comes with a royalty-free Access Runtime that
you can distribute with your app.
Click to expand...

Actually, no it doesn't. Up until 2007 you needed to buy the variously-named
Access Developer's Edition. The runtime will be free with 2007 but it has not
yet been released (well, it was released and immediately retracted when some
interactions with other programs turned up).

See http://www.granite.ab.ca/access/msmodfixes.htm for the proper version.
Some of these may be hard to come by at this point.

John W. Vinson [MVP]
 
R

Rick Brandt

Ron said:
Yes, but not a .EXE. You compile your project to a .MDE (Tools |
Database Utilities | Make MDE). It is wise to first split your app so
that the tables (data) exist in the back-end database, which you do
*not* compile. If you have Office Professional, it comes with a
royalty-free Access Runtime that you can distribute with your app.
Search the Office Professional CD - I think it is in a folder called
Runtime but search for accessrt and you will find it.
Click to expand...

You are correct that the runtime is included wtih Office, but you are not
licensed to distribute it to users without puchasing the developer's tool kit
package.
 
T

Tony Toews [MVP]

John W. Vinson said:
See http://www.granite.ab.ca/access/msmodfixes.htm for the proper version.
Some of these may be hard to come by at this point.
Click to expand...

Even the A97 KB article still exists so patches are easy to come by still.

No idea as to A95 or A2.0. <smile>

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top