Multiple User edit rights

[Bob K.]

Hi,

I'm building a small db with about 100 users. I will build the front-end
with Access but it will be connected to a SQl db. I need to allow users to
add and edit their own records but not those of other users. Is this
possible with Access or should I look elsewhere for a front-end dev tool.

Thanks

 

[RTL]

If you're using SQL, you can use a View to just allow them to see only their
records. I'm assuming that you're tracking who's record is who's?

Cheers,

Rich

 

[Bob K.]

Thank Rich.

Actually I would like everyone to see all of the records but only want a
user to be able to edit/delete their own records. This db will show various
maintenance records and I want the person responsible to able to update
their record on a daily basis. Other users can check the status of the
record but not alter it unless they are the owner.

Hopefully this is a little clearer as I was not so in my original post.