database locking/protection

  • Thread starter Thread starter BNK
  • Start date Start date
B

BNK

Hi, I have an access database that has 5 users on a network, I want two
users to be able to add and change data, but I want the other users only to
be able to add data, and not be able to make changes. Are there any
settings that will enable me to do this?

Thanks
Barry
 
I have split my database and distributing the the front end(MDE) to m
users. In that front end access to forms are determined by Access use
ID. Here is an example of the code.

On Error GoTo Err_Command98_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord,
acMenuVer70
Dim stDocName As String
Dim Baduser As String

If CurrentUser = "userid" Or CurrentUser = "Admin" _
Then
stDocName = "form name"

DoCmd.OpenForm stDocName, , ,
Else
Baduser = "Sorry ... you're not authorized to access that item."
MsgBox Baduser
End If

Good Luc
 
Thanks for all your help,
I'll try all methods to see what is the best for my situation.

Thanks again

Barry
 
Back
Top