user security settings

D

Dan

I am modifying the security settings of my database and there is one table
that I don't want the users to be able to change the data in. They need to be
able to enter edit and delete data but is there anyway to make it so that
users cant change the data in just one table? Also is there anyway so that
the users can't open the database window. I have it so that it isn't
displayed at start up but is it possible so that when the users press the F11
key that the window will not come up?
 
D

Douglas J. Steele

The only way to accomplish your first request is to apply Access security,
which isn't for the faint of heart! <g>

Read the Access Security FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp
thoroughly several times. Work with a copy of your database, and make sure
you don't leave out any steps. If you have problems or additional questions,
there's a newsgroup related specifically to Access Security where you'll be
able to get help.

As to the second part, you can create an AutoKeys macro that remaps the F11
key to do something benign. Make sure, though, that you provide yourself
some way of getting into the database!
 
Top