How to restrict few users for accessing reports in MS Access 2007 VBA

[chintu4love]

I need a help as I am new to the development aspect of access with Vba and I had to restrict few users ( i need to get users from environ function ) not to see the reports and some forms in the access database. And for few users i need to give full access for the database, Will you help me with this by providing the entire code so that I can understand it much better. Thanks in advance

[twinnyfo]

chintu4love,

Please access this article, and see if it guides you in the right direction:

How To Create User Permissions and Customized Menus in MS Access

[chintu4love]

Hi thank you so much, Can you please send me a copy of this database so that it will be self explanatory for me to learn. Thanks in Advance :) :)

[twinnyfo]

If you follow the steps in the article it should be pretty self explanatory.