[AccessD] Record security

Gustav Brock Gustav at cactus.dk
Sun Apr 2 05:52:41 CDT 2006


Hi John

Store (or retrieve) the login name somehow to variable strLoginName.
Then use the OnCurrent event:

  Dim booEdit As Boolean
  
  With Me
    booEdit = Not CBool(StrComp(!UserName.value, strloginName))
    .AllowDeletions = booEdit
    .AllowEdits = booEdit
  End With

/gustav

>>> joeget at vgernet.net 02-04-2006 12:19 >>>
Anyone
In this database, each record entry has an individual field for name.   I would like anyone to view another individuals records but I am trying to prevent another individual from editing or deleting a record that does not belong to them.  Does someone have an example of a login process and then disabling a record from being deleted or edited by another individual.  I tried the security wizard but I could not seem to get it to work.  There is a delete and edit buttons on the form for each record displayed 
Thanks for the help
John  




More information about the AccessD mailing list