Record Security setup

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I am new to access security. I have a database setup and running. User do
data entry through forms. I create a popup menu hoping to create a way for
user to click on the Edit (by unlocking the form control), but every user
can edit it,

Is there a (practical) way to only allow the onwer of the record to edit
specific record?

SF
 
SF said:
Hi,

I am new to access security. I have a database setup and running. User do
data entry through forms. I create a popup menu hoping to create a way for
user to click on the Edit (by unlocking the form control), but every user
can edit it,

Is there a (practical) way to only allow the onwer of the record to edit
specific record?

SF
Click to expand...

Yes. Store the current user's name in the record when it is created and
then use the form's Current event to test the username field and set the
AllowEdits property accordingly.

HTH - Keith.
www.keithwilby.com
 
Back
Top