Network security

11 Aug 2006 4:01 PM

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.

11 Aug 2006 4:49 PM

Rick Brandt

mwest wrote:

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

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

13 Aug 2006 7:24 PM

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.

--
Joan Wild
Microsoft Access MVP

mwest wrote:

Show quoteHide quote

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