Conditional Update

R

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
 
A

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.
 
Top