I have a question I have this login form which is really good but I want to add a Dlookup in it to pull certain information from the querys when you log into it I also a login that does this but I like this login better
if anyone can help I will email this database login to you [email protected]
i have an interesting question.....so with this login security, i have a form with a quiz on it can i have them login like normal but only on certain occasions give them access the the link that goes to the quiz form? like for instance the admin guy has sec. lvl 1 and everyone else has lvl 2.....but can i set the sec. lvl for the quiz to say 3, and then say dec. or jan. add that lvl of sec. to the users so they can access it? i hope i didnt lose anyone...thanks
Yes, The access level for each user can be changed anytime by the administrator of the database by using the Add/Edit users menu item which open frm_users.
Alternatively, you could add the Quiz as a menu item to security level2 that would open the quiz, then go into the table that is used to display the menu for security level 2 in the demo version this is switchboard_lev2 make a note of the value in SwitchboardID for the quiz menu item and store in the description field (this will be used later as required). Now go back to the SwitchboardID for the quiz menu and change the existing value to 999.
By changing the value to 999 the user will not have the quiz menu item displayed as most likely you will not have a menu page number(SwitchboardID) with a value of 999-in your current database. when you want to display the quiz change the SwitchboardID 999 to the previous value you stored in the description field. Have I lost you?
The alternative method will be more efficient than trying to change the access level for each user.
I'm trying to make DB with simple user login form and afterwards I want to apply user stamp ID on all data that is modified or created in other form. I was using your template with utility form, but I constantly ran into problems.
This is the code part:
DoCmd.OpenForm "UtilityF", , , , , acHidden
Forms!UtilityF!EmpID = Forms!LogInF!EmpID
LogInF - Login form
UtilityF - Utility form
EmpID - Employe ID, AutoNumber in User table
What I get as error message is Runtime error '2448' : "You can't assign a value to this object."
Since I'm VB/Access newbie, can you please tell me what could be the problem?
Open frm_main use either TEST1, TEST2 OR TEST3, the user ID determines the level of access. Whne you first login you will asked to change the password as the password has expired. This is a feature that I use as a bit of security etc.
have created a back end access sheet which is linked to access user form. but the location is different for both.
i have used have used the path to define location for backend form. is there any way where can i use you form to save credential in my backend and users can validate their credential from there. Kindly assist.
If you want a form to manage you user credentials, then just create a form as per your requirements and then set the record source to the tbl_users in your backend database. For security reasons be careful not to allow everyone have access to this form. You will also need password and access level on this form so that you can change the access level and reset the user's password etc.
I look up to see if the Windows user is in a local user table. If found then I run the code to log in the user with that user name.
I have not used it, but I have seen way to get more Active Directory (AD) information about the use, like security groups. This would allo you to make a more fully integrated security system using AD.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
If you want a form to manage you user credentials, then just create a form as per your requirements and then set the record source to the tbl_users in your backend database. For security reasons be careful not to allow everyone have access to this form. You will also need password and access level on this form so that you can change the access level and reset the user's password etc.
I look up to see if the Windows user is in a local user table. If found then I run the code to log in the user with that user name.
I have not used it, but I have seen way to get more Active Directory (AD) information about the use, like security groups. This would allo you to make a more fully integrated security system using AD.
but this describes user only. would like to valodate the password also from system (windows authentication)
If you want a form to manage you user credentials, then just create a form as per your requirements and then set the record source to the tbl_users in your backend database. For security reasons be careful not to allow everyone have access to this form. You will also need password and access level on this form so that you can change the access level and reset the user's password etc.
Hi Allan,
below is code which would like to modify as per my requirement.
my requirement is to save credential in backend database named "tbl_users"
have already created tbl_users. but want to know how to address the table/file through code.
Sub display_menu()
On Error GoTo err_display_menu
' at this stage the userId and access level has been checked
Dim access_level As Integer
Dim finish_Date As Date
Dim port_syd As String
Dim valid_user As Integer
Dim check_user As Integer
Dim password_period As Date
Dim check_password As String
Dim strmsg As String
Dim Connection
Dim Rs1 As ADODB.Recordset
Set Connection = CreateObject("ADODB.Connection")
Set Rs1 = New ADODB.Recordset
Connection.Open (Databasepath)
Reply With Quote
Originally Posted by Allan Murphy
