Yes I would like a copy of your login demo. I am having trouble creating one.
email me at meds22cathy.co.uk.
Thanks Cathrine.
Printable View
Yes I would like a copy of your login demo. I am having trouble creating one.
email me at meds22cathy.co.uk.
Thanks Cathrine.
Cathrine
Have a look at message 44 on this thread.
Cathrine
Your email address is invalid.
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
John
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.
Hello Allan, first of all - this thread is great. :)
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?
Hello Storvagun
Please send me a copy of your database with just the login and utility forms and I will have a look at your problem.
Is there any way where we can use windows authentication to login the form.
__________________________________________________ _______________________________________________Quote:
Originally Posted by Allan Murphy
Dear Allan,
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.
[QUOTE=sonia;132051]Is there any way where we can use windows authentication to login the form.[/QUOTE
Sure. I do that a lot.
I use this to get the Windows user name: http://access.mvps.org/access/api/api0008.htm
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.
Thanks alot allanQuote:
Originally Posted by Allan Murphy
[QUOTE=HiTechCoach;132061]but this describes user only. would like to valodate the password also from system (windows authentication)Quote:
Originally Posted by sonia
Hi Allan,Quote:
Originally Posted by Allan Murphy
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)
Rs1.Open "tbl_users", Connection, adOpenDynamic, _
adLockOptimistic, adCmdTableDirect
valid_user = 2
' **********************************************
' validate user_id
' **********************************************
check_user = DCount("[user_id]", "tbl_users", "user_id=forms!frm_main!user_id")
If check_user = 1 Then
valid_user = 2
Else
valid_user = 0
End If
' **********************************************
' validate password
' **********************************************
If valid_user = 2 Then
check_password = DLookup("[passwords]", "tbl_users", "user_id=forms!frm_main!user_id")
If UCase(check_password) = UCase(Forms!frm_main!password) Then
valid_user = 2
Else
valid_user = 1
End If
End If