 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
February 10th, 2004, 06:23 AM
|
|
Authorized User
|
|
Join Date: Dec 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Passwords
Is it possible to create a password system in Access? I need to have multiple users with different user names and passwords to access different parts of the database.
If any one knows how this is done could you please let me know as it would be most appreciated!
Thanx
Sam Powell
Information Systems Officer
Neath Port Talbot College
__________________
Sam Powell
Information Systems Officer
Neath Port Talbot College
|
|
February 10th, 2004, 11:20 AM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
It is actually pretty easy to accomplish this. I have tried using Access security and workgroup files and unfortunately never got that to work properly. So with necessity being the mother of invention I created my own workgroup file. First I have a table that lists specific info about the users (strFirst, strLast, strEmpNumber (PK), strPassword, strLevel). Second I have a Login form that asks for UserName and Password; UserName is listed in a ComboBox that has the LimitToList property set to true, Password is verified against the tblUser.strPassword for verification. If the password matches strEmpNumber (which is how I set it new new users) then they are prompted to change before proceding. From the ComboBox with the user name a load a Global variable for the strLevel (gstrLevel). This can be referenced throughout the application to enable/disable respective application componets and controls. I also have a form that will allow password changes and resetting.
So, yes it can be done. Initially it is a bit of work but after that the only maintenance is when a new user is added or one is deleted.
Hope this helps you.
Kenny Alligood
|
|
February 10th, 2004, 11:58 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
See the Security FAQ at the following link:
http://support.microsoft.com/default...93&Product=acc
Watch out for word wrapping on the url!
Regards,
Beth M
|
|
February 10th, 2004, 12:02 PM
|
|
Authorized User
|
|
Join Date: Dec 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
quote:Originally posted by Kenny Alligood
It is actually pretty easy to accomplish this. I have tried using Access security and workgroup files and unfortunately never got that to work properly. So with necessity being the mother of invention I created my own workgroup file. First I have a table that lists specific info about the users (strFirst, strLast, strEmpNumber (PK), strPassword, strLevel). Second I have a Login form that asks for UserName and Password; UserName is listed in a ComboBox that has the LimitToList property set to true, Password is verified against the tblUser.strPassword for verification. If the password matches strEmpNumber (which is how I set it new new users) then they are prompted to change before proceding. From the ComboBox with the user name a load a Global variable for the strLevel (gstrLevel). This can be referenced throughout the application to enable/disable respective application componets and controls. I also have a form that will allow password changes and resetting.
So, yes it can be done. Initially it is a bit of work but after that the only maintenance is when a new user is added or one is deleted.
Hope this helps you.
Kenny Alligood
|
That sounds like a great idea and i just tried giving it a go but im getting a bit stuck. Have you got any code for this or if possible can u give step by step instructions on how to achieve this.
Many Thanx
Sam Powell
Information Systems Officer
Neath Port Talbot College
|
|
February 10th, 2004, 12:03 PM
|
|
Authorized User
|
|
Join Date: Dec 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Thanx for the link, but it is coming up that the page is unavailable.
Sam Powell
Information Systems Officer
Neath Port Talbot College
|
|
February 10th, 2004, 12:07 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Copy and paste the whole url into your browser, or open your browser, go to Help > Online then click Search Knowledgebase. Select Access as the product to search by and enter the words:
Security FAQ
as your search criteria.
Beth M
|
|
February 10th, 2004, 02:51 PM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Not a problem. If you send me your eMail address I will forward you a DB that has all the code and forms for it.
Kenny Alligood
|
|
|
