Inhibiting access

J

JJ

How do I set the system such that tables, macrod code, etc. won't be acccess
by users ? All they should be able to do is use the form/screen.

Thanks in advance.
 
A

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
 
J

John W. Vinson

Would not other users be able to change those settings ?
Click to expand...

Not if you use a menubar which doesn't have the Tools... Options button set.

Actually, a sophisticated user determined to break your database can do so.
All you can do is make it more difficult... hopefully without making it so
difficult that you're unable to make improvements to the design yourself!

You should certainly be giving users a split database with the tables in one
backend .mdb (or .accdb or SQL/Server or whatever) database, and a frontend
..mde or .accde database; these databases won't allow much in the way of design
changes, and you can control what little design capability remains.

John W. Vinson [MVP]
 
A

Albert D. Kallal

Would not other users be able to change those settings ?
Click to expand...

Well, sure, but if you disable the shift key, and distribute a mde, then
they can't view, or modify the code anyway....

So, even if they "get in", what can they do????
 
Top