database locking/protection

[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

 

[cTaHk0]

Look in Tools->Security menu
regards
cTaHk0

 

[Arvin Meyer]

There are several methods, but the best is through user-level security.

Read (carefully) the Microsoft Knowledge Base Security FAQ for detailed
information:

http://support.microsoft.com/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Jim/Chris]

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

 

[BNK]

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

Thanks again

Barry

 

[fade]

ÚÝæÇð ÃäÇ áÇÃÊßáã ÇáÚÑÈíÉ

Look in Tools->Security menu
regards
cTaHk0