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
Sorry, Access doesn't support row-level security. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "theroundpen" wrote in message news:E26F3D76-EAC7-490F-83A7-70CD0F142175@microsoft.com... > 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" wrote in message news:E26F3D76-EAC7-490F-83A7-70CD0F142175@microsoft.com... > 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
