Restrict user access to specific records

[adamburton]

I have a staff database in my office which holds, amongst other things a list of staff holiday taken. Presently the staff have no access to view holidays because they will also be able to view other employees details. What I need to do is enable members of staff to see their own holiday, but no others and Im really not sure how to go about it.

I have a workgroup in place; so each user has their own login/password.

Any ideas would be gratefully received.

Thanks,
Adam.

 

[Bat17]

You do it by blocking access to tables and filtering queries by user. See section 10
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299671

Peter

 

[adamburton]

Thanks

Thanks Peter,

Ive had a read of the support page and think it makes sense. Could you advise what criteria I need to put in my query to point towards the current logged in user.

Hope that makes sense.

Adam.

 

[Groundrush]

This may be of some interest