Security on individual records

  • Thread starter Thread starter theroundpen
  • Start date Start date
T

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
 
theroundpen said:
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
Click to expand...

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
 
Back
Top