Remove permissions on both form and table

[Guest]

I've locked a form options field, using forms properties, but users can go to
table and edit. Options field on form does lock as needed. I've tried
changing user permissions, to prevent any modifications by table, but it does
not work. It either prevent editing to whole form or allows editing to whole
form. Same with table it either allows editing of all fields or none. Any
suggestions on how to lock out users on one field within table?

Using Access 2000, split DB, users using mde for access to DB. Both BE and
FE are on server.

 

[Joan Wild]

Your best bet is to lock them out of the database window and not allow them
to even see the tables.

Backup your database; you can easily lock yourself out playing around with
these features.

Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
set the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item)
uncheck the allow special keys (this will disable the F11 key, among
others)

If you need to bypass these startup features, you can hold the shift key
down while you open the db. If you feel that your users may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

 

[Guest]

Hi Joan,

Thanks for your suggestions. I already have a switchboard menu open up at
startup for users. However, some users have seen me use F11 to enter the
database window. I want to make sure no one uses this back door to get into
the tables. I'll backup my FE and try your suggestions. Since I'm not
changing the BE and no one opens the BE it will not be affected. Both BE and
FE are backed up every day (tape backup). They are a pain to restore so I'll
backup on my local drive. Users will get MDE copy of my FE. Thanks Again.

 

[Todos Menos [MSFT]]

set up AutoKeys so that F11 will prompt you for a password


or better yet; give them MDE and 100% lock them out


there is a derivative of the inputbox that is called PasswordBox on
google I think.. i've used it a ton; I just don't have it here in
front of me

I spend all my time retiring these little silly Access apps

-Todos

 

[Tony Toews [MVP]]

Todos Menos is not a Microsoft employee. This posting is by A a r o n
K e m p f.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm