rights according to the user

[tony wong]

is it possible to do that?

i have a table with a field "authorized user".

if the entry in the field (authorized user) of the record is "Tony"

The record can only be changed by "Tony" user.

If yes, how's the logic to do that? Thanks a lot.

Tony

 

[Rick B]

Sure.

If it were me, I would take away access to all the objects in my database.
I'd create a query that pulls up records and only displays the current
user's records...

[Authorized User] = UserID()

I'd change the query property to run using "owner's permissions" so that
your users could see the records without having access to the tables.

Then I'd tie that query to a form and give the users access to that form.

This similar question has been asked and answered many many times in this
group. Do a search and you should see other detailed answers. Basically,
you are trying to limit access so users can only modify their records.


Rick B



is it possible to do that?

i have a table with a field "authorized user".

if the entry in the field (authorized user) of the record is "Tony"

The record can only be changed by "Tony" user.

If yes, how's the logic to do that? Thanks a lot.

Tony