User management - Access 2010

[BevR]

Hi,

I'm relatively new to Access. I've built a database that I now need to share with 5-6 other users on a network. What I'd like to do - and desperately need your help with - is assigning permissions to the users using their network logins. I've researched a lot in the past few days on getusername, and have the module for that. However I'm unsure as to how to proceed from there and grant permissions to certain forms/reports. I have a Users table with fields UserID and Full Name. Please help!

 

[gemma-the-husky]

first - instread of a complex procedure, simply environ("username") returns the windows login name of the user.

what you have to do is build some code into every object - say in the openevent - that tests the usersname and determines whether to open the form. no short cuts, really

this is why most systems have usergroups, rather (or as well as) than users.

so you join the users into a "user" group, and the admins into a "admin" group - and then you only need 2 options in the form.

new users are just assigned to whatever group is relevant.