Network security

[mwest]

I am using Access 97, I have completed building the program, there will be
other users who will be using the program. Is there any way to set it up so
that they can view the records, and add new ones, but not be able to alter
anything already entered, or change the forms.
I have tried to set up an admin security, but half way through I was locked
out and had to back up the computer to gain access.
Thanks in advance.

 

[Rick Brandt]

I am using Access 97, I have completed building the program, there
will be other users who will be using the program. Is there any way
to set it up so that they can view the records, and add new ones, but
not be able to alter anything already entered, or change the forms.
I have tried to set up an admin security, but half way through I was
locked out and had to back up the computer to gain access.
Thanks in advance.

You can use network security to keep people completely out and you can use
it to make the file read only for *everyone*.

If you need a mix (different permissions for different people) then you
cannot do that with network permissions. You have to use the User Level
Security built into Access which as you saw has a steep learning curve and
should only be tried on test files until you get it figured out.

 

[Joan Wild]

If you don't want to implement security, you could set the Allow Edits and
Allow Deletions properties of your forms to No.

You'd also need to lock down the mdb, so that users can't get to the db
window; create your own custom menus/toolbars, and also create a MDE.