Conditional Update

[Ramko]

Greetings,

I have a databse used by different users. The issue I am facing is how to
allow users to update their own records only. And prevent them from updating
other users' records. Of course, they can display any record.

I am not expert in MS Access and need your help...

Thanks for any help.

Ramko

 

[Allen Browne]

How do you define "their own records"?

Do you have a field in each table that identifies who owns what? If so, you
could use the Current event of the form to lock/unlock the record in that
form, based on the value of that field.