Unique Username and Password with specific permissions for each

[izzygrace3]

I have completed a database for work, but I have been researching for a way to create a login screen where each user creates their own username and login. I would also like to be able to only allow certain permissions per user. Is there a way to do this in Access 2007?



Any help would be greatly appriciated.

Thank you in advance!

[ajetrumpet]

the easiest way to do it is to probably store the information in tables. that's the only way I've ever done it.

for instance, a users table with one field per activity. YES/NO check box to indicate if that person can perform the activity.

or something similar. many ways to do this. What I usually do though, is store the information in tables and have a couple of global functions I use when activities are requested. For instance, functions called IsAdmin() and HasRights() are good ones to return a boolean to see if the user that's logged in can do the activity they request.

[izzygrace3]

thank you for the help, Adam.

The truth, however, is that I am pretty new to access and while I understand what you are saying but I am just not sure how to institute it. Do you have a sample database that I can look at or anything like that?

[ajetrumpet]

thank you for the help, Adam.

The truth, however, is that I am pretty new to access and while I understand what you are saying but I am just not sure how to institute it. Do you have a sample database that I can look at or anything like that?

Yes I can do that, since you asked so kindly.

Attached is such. Some login code runs and useful after you login. The privalege based code that you're probably interested can be run when you click SPEC SHEETS or COA REPORT, which are buttons near the top of the main form GUI.

Some of the other global functions you might be interested in as well. Most of the objects and all of the data is deleted out of this file, but this was one of the most effecient databases that I've ever built with a size under 5MB.

So, IMO, it's a great learning tool for someone learning this program. This was built completely off of the Northwind model but 90% of the database is run off of only a few function call concepts.

Compared to the actual product though, there is practically no code here, but it's still some learning material! There certainly is some help in it that can teach you how to make repeatable operations very efficient by eliminating redundancies that "box thinkers" usually produce with their products.

[izzygrace3]

Thank you so Much, Adam. You are now my hero.

[ajetrumpet]

Thank you so Much, Adam. You are now my hero.

do I get a uniform and a cape and everything?