Security on individual records

[theroundpen]

Is is possible to set security on an individual record so that different
people could modify a database, but only certain records they had access to
(no pun intended! )?

Thank you very much for your help.

Carla McDonald

 

[Douglas J. Steele]

Sorry, Access doesn't support row-level security.

 

[Keith Wilby]

Is is possible to set security on an individual record so that different
people could modify a database, but only certain records they had access
to
(no pun intended! )?

Thank you very much for your help.

Carla McDonald

Yes you can but you would have to have User Level Security set up and have a
method recording the user's ID. You could then have code in the form's
Current event to check the recorded ID against the CurrentUser function.
For example, if your user's account name is "JBloggs", you would record that
in a text field when the record is created. Then, in the form's Current
event, something like:

If Me.txtUserID = CurrentUser Then
Me.AllowEdits = True
Else
Me.AllowEdits = False
End If

HTH - Keith.
www.keithwilby.com