Security - record based

[Aniz]

Is it possible to say give access to users based on
records? For example I have 1 record per employee to
enter their weekly activities and would like only that
employee to be able to access his/record record.

 

[Rick]

If you tie the form to a query that has their userid as a parameter, then
only their record would show. Make sure they can't edit the query or get
around it.

If I understand it correctly, you would have to take away their table access
so they could ot simply open the table. In order for them to still run the
query, you must change the query properties to Run Permissions = Owner's.

Rick

 

[aniz]

Hi Rick,
Thank you for your response. I am trying to bind the form
to the query through Control source and am not getting any
results. Is ther any other method?

Aniz