Table Security

[wizkid]

Is there a way for people to be locked out of a table but still access the table through forms. I tried using the user security but i couldn't access the tables through the forms. So they can't change the table. But can add and modify through forms.

 

[ghudson]

In addition to setting the user permissions so that a user can only access the db objects [tables, forms, reports, etc.] you need to disable their ability to view the database window so that they can not pick and choose the db objects for viewing or worse, editing the design of the db object. You should also remove the standard menu bars and tool bars. The user should only be able to navigate to the forms that you allow them to open and view based on the menu navigation you desing. A user clicks a button to open a form, they click another button the close the form and open another. It is easier to adjust the users ability to view/edit/delete/add records based on their user name or workgroup via code within the form. Like this...

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

    If CurrentUser = "User1" Then
        Me.AllowAdditions = True
        Me.AllowDeletions = True
        Me.AllowEdits = True
    If CurrentUser = "User2" Then
        Me.AllowAdditions = True
        Me.AllowDeletions = False
        Me.AllowEdits = False
    Else
        Me.AllowAdditions = False
        Me.AllowDeletions = False
        Me.AllowEdits = False
    End If
    
Exit_Form_Open:
    Exit Sub

Err_Form_Open:
    MsgBox Err.Number & " - " & Err.Description
    Resume Exit_Form_Open

End Sub

More details to what I mentioned is posted all over this forum. Search around and study the info the others have posted.

I will offer this link to some code to remove tool bars and menu bars and to hide the db windows...
hide all Access tool bars and menu bars

 

[kedarj]

What are the steps I should follow? I want to have the following:
Administrator - Who can change forms and do everything
Editors Group - Can change some forms
Reviews Group - Can only see the Reports section
Can you help me understand, how I can do this?
Thanks
K

 

[MsLady]

*bumpity bump