Wrox Programmer Forums
|
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
 
Old February 10th, 2004, 06:23 AM
Authorized User
 
Join Date: Dec 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
 
Old February 10th, 2004, 11:20 AM
Authorized User
 
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 10th, 2004, 11:58 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 10th, 2004, 12:02 PM
Authorized User
 
Join Date: Dec 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 10th, 2004, 12:03 PM
Authorized User
 
Join Date: Dec 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by BethMoffitt
 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
Thanx for the link, but it is coming up that the page is unavailable.

Sam Powell
Information Systems Officer
Neath Port Talbot College
 
Old February 10th, 2004, 12:07 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 10th, 2004, 02:51 PM
Authorized User
 
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Accepting Passwords in C++ aix_kernel C++ Programming 0 August 9th, 2008 12:58 AM
Generate Encryped Passwords PDALUX ASP.NET 2.0 Basics 6 August 15th, 2007 06:53 PM
Where and how to store encrypted passwords usprasad_m Visual C++ 2005 0 December 15th, 2006 07:01 AM
Message Boxes and passwords jackdaddy Javascript How-To 5 November 27th, 2004 11:24 PM
Change passwords in another workgroup Steven Access 0 July 2nd, 2003 07:27 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.