How to limit users views

[Richard]

I have recently set up a database which has a number of users. To prevent any
inadvertantly deleting tables etc, I want to limit the users to using /
viewing only the forms which navigates then to the relevant section of the
database. Simply put I want to stop the tables view when opening the database
(I done it in the past and can't remember how...old age is not as much fun as
I was told!!!!)

Thanks in anticipation.

 

[Maurice]

Richard,

You should disable the database window in the startup window. Furthermore if
possible create an .mde file from the db. Include the bypass feature to make
sure people can't get in by using the shift button.

http://www.mvps.org/access/modules/mdl0011.htm

hth

 

[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. 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

 

[Richard]

Albert,

Thank you very much for your help. I will try this tomorrow in work.

Regards,

Richard

 

[Richard]

Maurice, Thank you also for your reploy. I will try your method some time
soon as I develop the database further.

Regards,

Richard