Need opinion ...

[Guest]

I would like to restrict modifications to a table (Say TableA) based on
userid.
I have user information allowed to modify records in TableA in another table
say TableB. The two table are connected with a key.

If I write a query joining two tables to pull up records that the logged user
can modify, then I cannot modify the records since it is a join on two tables.

Another way would be for users to enter the Key for the 1st table and
then I verify if the user is allowed to modify the requested record.
Our users here don't want to do that, they want to view all the records they
are authorized to modify and then modify the record if they choose to do so.

How can this be accomplished?

Thank you,
-Me

 

[ruralguy via AccessMonster.com]

Here's a couple of links that you may find helpful.
Enabling/Disabling controls, based on User Security
http://allenbrowne.com/ser-15.html
Field-level Permissions in Microsoft Access
http://allenbrowne.com/ser-55.html

 

[Guest]

Thank you ruralguy,
-Me

Here's a couple of links that you may find helpful.
Enabling/Disabling controls, based on User Security
http://allenbrowne.com/ser-15.html
Field-level Permissions in Microsoft Access
http://allenbrowne.com/ser-55.html

 

[ruralguy via AccessMonster.com]

You're welcome. I hope they helped.

Thank you ruralguy,
-Me

Here's a couple of links that you may find helpful.
Enabling/Disabling controls, based on User Security

[quoted text clipped - 19 lines]