making an exe object said:
Can someone help me on how to make an executable object out of the access
database.
Right now when i double click on the access application, it interactively
opens in access. It protects the forms, reports, pages etc. I does not
allow
me to change the design. But i can change the data by directly accessing
the
queries or tables.
What i need is that the application should not open interactively in
access,
it should open as a normal executable application.
Access does not support what you want. To distribute an Access database to
users who don't have Access, you distribute the database with the runtime
support... which is a copy of Access with Design View and design functions
disabled. MVP Tony Toews has good information on runtime topics at his
site,
http://www.granite.ab.ca/accsmstr.htm. Runtime came as a separate
option, or sometimes required a Developer Edition of the Office product, in
the past, at extra charge -- and most successful users also employed one of
the third party software packages for creating an installable package (I had
some experience with the Wise product on one project a few years back, and
investigated InstallShield for that same project. At the time, Wise had
capabilities for Internet that InstallShield did not, but it was not long
until InstallShield "caught up". There are some Open Source installers,
also, that people have mentioned (but I've never used them) -- one is named
Inno.
If you are working with MDB or MDE files, you can use Access security to
limit users' access. It is possible to lock down an application so that the
users can only access data via your forms and queries. (That said, you
should be aware that Access security, like any security to which you give
users access, can be broken.)
Larry Linson
Microsoft Access MVP