Allow certain users access to only certain forms

[chuckcoleman]

Hi, I'm building an Access application using Office 365 where certain users won't be able to access certain forms and certain reports. Before I start coding, I thought one way would be to build a table with certain information, the users email address, a password field and fields, (check boxes), related to which forms and command buttons I wanted them to be able to see or have access to. For the typical user, this might work but I'm concerned if they ever got an Access "smart" person, this would be pretty easy to crack.

Are there any good ways to accomplish this? The clients will have "local" forms and a few "local" tables but most of the tables will be on a SharePoint List, which I'm just starting to learn about.

Any ideas, recommendations?

 

[isladogs]

The easiest way is probably to apply user access levels
e.g. Level 1 - read only access
Level 2 - edit certain form data but no access to other forms
Level 3 - edit all form data but no changes to design - no access to code
Level 4 - complete access to all parts of the application

This requires users to login with username/password
See this example on my website to help you get started: http://www.mendipdatasystems.co.uk/password-login/4594469149