Security on individual records

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
 
K

Keith Wilby

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
 
Top