how to make access database,forms and reports executable

[gudiya]

Hi,
Please can anyone tell me that how to make an executable
file in Access 2000. I have created reports, forms and a
switchboard in access now I want that the user should open
the application with switchboard as front page and the
user should not be able to see the tables and records in
the database. basically the architecture behind the
application should remain hidden.

Also is it possible that user can run forms for data entry and
edit in the database tables and see and print reports from the
database tables without having ms access on their computers

Please tell me the complete procedure that I need to follow
Thanks

 

[Albert D.Kallal]

There is two separate questions you have.

#1. Hide the ms-access interface. This issue has really nothing to do with
building a executables (question #2!!).

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

#2 - build a executable....

There is no means to create a .exe, but you can as a general rule use the
developers tools to build a windows install. If you done step #1, and built
a custom interface, then you are well ready to use the developer edition of
ms-access. You do for the most part have to build the menus etc.

Here is some information

http://msdn.microsoft.com/library/d.../odc_ac2003_ta/html/odc_acbasicsofruntime.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;842004

 

[Klatuu]

There are a number of things you will have to address. First, Access does
not compile to an executable. Users must have either the full Access version
on the Access run time version. To control what users are allowed to see and
do, you will want to create an mde file and distribute that rather than the
mdb. That will keep them from being able to modify any objects, but they
would still be able to directly manipulate data in the tables.

To control that, you will want to hide the system menu, create your own
menys, open a form at startup (your switchboard), and hide the database
window. This is just for starters and is still not that secure.