Remove All Toolbars and buttons

[Simon]

I have an Access 2007 Database that i want to give out to users but do
not want all the Access buttons, all i want is by dadabe to load as
every thing can be controled from this.


How do i remove all toolbars and buttons

Thansk

SImon

 

[Albert D. Kallal]

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.
(or, in 2007, office button->access options->current database).

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
(there is also a 2007 example)

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

I don't have a 2007 version of the shift key, but the above should modify
easy...

 

[Albert D. Kallal]

You should create a accde for your users (and that quite much means you have
to split your database, else there will be no way to issue updates to code).

Anyway, the options to hide just about everything can be found via

office button->access options-> current database.

Try downloading the 2007 example I have here:


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

To look inside, exit, and then hold down the shift key during startup...