Active directory user identification

[ppataki]

Dear All,

I have a database that contains data for all the users (data like salary, etc)
The users are maintained in Active directory
(and also in Microsoft Outlook 2007)

I would like to somehow achieve that if a user opens the database he/she can only see his/her data (so basically his/her record) only

Could you please give me some hints?

Many many thanks in advance

 

[pbaldy]

A friend has posted a blog and sample db demonstrating using AD for security:

http://www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx