Only the user who created the record can change data in a field

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I am using a Data Access Page as my front end and SQL 2005 as my back end. I
am trying to only allow the Active Directory User who created the record to
be the only one that change/edit/delete data in a field.
 
Its a very bad idea. What happens when the person is out sick or on vacation?
However, if you insist, simply store the userid of the person who created
the record in the record. Then when the record is retrieved compare the
userid in the record with the logged-on user and if different, lock every
control and set allowedits to false.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top