Access 2010 - Restricting User Access

[Farida]

Hi, I have Access 2010 database.


I have a Reporting Dashboard form that inturn has many buttons to open up different reports and forms.

Now i have been asked to extend the access to a few other users with restricted access. The new users cannot see all the form and report buttons in the Reporting dashboard form.

How can i restrict this? They also need to be given seperate logins and passwords.

Please give me step-by-step instructions on how i can accomplish this?

Thanks!

[JoeM]

First off, in a multi-user environment, it is a best practice to split the database into a Front-End and Back-End, if you have not already done so. Here is an article that discusses why and how you would do that: https://support.office.com/en-us/art...3-51b1d73498cc

Once you have done this, you usually distribute copies of the Front-End to the different users that they run from their Desktop. Note that you can have different Front-End versions tied to the same Back-End. So you can make different versions of the Front-End for different user groups, depending on each one's needs.

[NTC]

There is no embedded feature; one must write it from scratch. You must have a table that holds the Users. A screen form for them to log in. Logic that verifies their log in information. Then logic with toggles availability of controls (buttons) based on their log in.

Probably beyond the scope of a self described novice, but otherwise fairly mainstream in terms of application and database development tasks.