User Authentication !!!
Apr 14, 2005
Hi All,
Im a beginner in Access.I created 2 tables-First one has the User-ID , Password and other details, Second table has All the personal details of those users.I have created a form with 2 text boxes and a button. The User enters his ID and Password and "Submits" it.
I want to check his User-ID , Password with the data present in the table and if that is correct- display another form with all his details...
How do I do that..?? please help me with this...
Thanks in Advance...
bye.
View Replies
ADVERTISEMENT
Jan 1, 2008
Alrighty -
After learning that 2007 has no User Security roles, and not having Sharepoint or a SQL server, I decided to work starting with Bob's Simple Login script located here (http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx).
I've got it functioning fine and incorporated some of the options also made available here (http://www.databasedev.co.uk/login.html).
You'll see the code below used to store info in a hidden form that is holding the username and permissions level. I'm looking to try and store this information into a global variable instead of a hidden table.
I know that I could define it as a variable right here in the code, but how do I define it as a Global variable so I can use it later in the application in the VBA?
Private Sub cmdLogin_Click()
Dim strUser As String
Dim strPWD As String
Dim intUSL As Integer
strUser = Me.txtUser
If DCount("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'") > 0 Then
strPWD = DLookup("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'")
If strPWD = Me.txtPwd Then
intUSL = DLookup("[SecurityGroup]", "tblUsers", "[UserName]='" & Me.txtUser & "'")
Forms!frmUSL.txtUN = strUser
Forms!frmUSL.txtUSL = intUSL
Select Case intUSL
Case 1
DoCmd.OpenForm "frmHome", acNormal
Case 2
DoCmd.OpenForm "frmHome", acNormal, , , acFormReadOnly
Case 3
MsgBox "Not configured yet", vbExclamation, "Not configured"
Case 4
MsgBox "Not configured yet", vbExclamation, "Not configured"
End Select
DoCmd.Close acForm, "frmLogin", acSaveNo
Else
If MsgBox("You entered an incorrect password" & vbCrLf & _
"Would you like to re-end your password?", vbQuestion + vbYesNo, "Restricted Access") = vbYes Then
Me.txtPwd.Value = ""
Counter = Counter + 1
If Counter = DLookup("[OptionValueNum]", "tblOptions", "[OptionsID]=1") Then
MsgBox "You have entered an incorrect password too many times. This database will now close!", vbCritical, "Wrong password!"
DoCmd.Quit
End If
Else
DoCmd.Quit
End If
End If
End If
End Sub
View 4 Replies
View Related
Oct 4, 2005
For a databse which I am going to create, I would like to have an authentication system which utilises the database users which I specify, however instaed of using a password the idea would be to use a fingerprint scanner to logon. T^his would be for an A - Level IT project and I would seriously like to know how to integrate biometric security into a database. If anyone knows how to do this please post CLEAR instruction possibly with some SCREENSHOTS if possible.
Thanks
View 1 Replies
View Related
Jul 12, 2005
Hi.
I recently created SQL SERVER backend for my MS ACCESS app. (I upsized ONLY the tables, so the ACCESS app contains linked tables).
The SQL SERVER resides on a different machine than the MS ACCESS app.
Every time that I run the ACCESS app, it fails to connect to the SQL SERVER ("Login failed for user 'xxx'") and it prompts me for user name and password.
After I give it the right user name and password, no probs.
The problem is that ACCESS doens't save the new user name and password.
So every time that I run the app, again, it uses the wrong default user name and password (I don't know where it gets it from), and I need to re-enter the correct one.
HOw can I solve it?
Thank you very much
Roy
View 3 Replies
View Related
May 22, 2013
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
View 3 Replies
View Related
Aug 4, 2007
Hi guys,
I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...
We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...
Best ideas anyone?
dazza61
View 6 Replies
View Related
Apr 24, 2013
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
View 1 Replies
View Related
Oct 28, 2004
I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".
My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.
Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.
Thanks in advance.
Regards Peter
View 5 Replies
View Related
Jul 31, 2014
I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.
But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.
View 1 Replies
View Related
Sep 2, 2014
Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?
View 4 Replies
View Related
Jul 26, 2005
I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.
I already searched these forums and googled for help.
View 13 Replies
View Related
Nov 29, 2005
i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)
View 2 Replies
View Related
Apr 7, 2006
Can someone direct me to help with setting up User rights? I've always been the only user, but now I have multiple people working from my database and want to limit there authorizations. Also, is it possible to have someone actively using the database while I continue to make changes for forms and reports?
Thanks in advance for the help.
View 2 Replies
View Related
May 9, 2006
hi. i just wanted to know how to get a litle yellow box to appear saying enter text here when the user puts the cursor over a field where hey enter text on a form. thanks
View 2 Replies
View Related
Aug 31, 2006
Hi I am new to Access and just need some advise.
I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items.
I want to make an access database to hold all this info.
Should I make one table to record all information from the 5 spreadsheets or have a seperate table for each.
Any advise would be most appreciated.
Tks
View 4 Replies
View Related
Mar 17, 2007
Hi all
Well ive been using this forum for about a month now, and as an inexperianced user of Access D/B I find this forum is a wealth of information from the cream of Access programers. I have bought DVD courses of ebay in the past but has no comparison to the knowledge on this forum.
Thank you all.
Chris
View 2 Replies
View Related
Jun 9, 2005
Hi guys,
im a new user of Access and don't really know what im doing.
i need to make a database that will keep track of technical drawings. I need the database to be able to search for a drawing number, we might have a few of these types of equipment, so if i am adding a drawing of a different piece of the same equipment i need it to automatically generate the next number in the sequence.
This is hard to explain...
Ok, i have a load of Drawings, say they are numbered
0010-020-A-001
0020-020-A-001
0030-020-A-001
Right the first part is the type of equipment, the second is the sub-group, the thirs is the drawing type....this will all be entered by the person whois entering it into the register, the 001 at the end means it is the 001 revision of the drawing. If i have made a new revision of the drawing, say 002, i want to be able to use a form to enter the first bit of the serial number, then it will automatically tell me the next number in the sequence, and will let me fill in the other details, then i can click a button "add" or register or something and it will automatically update all the details...
....i would be so grateful if anyone knows a solution to this, or if this is even possible
thanks in advance
Cokes
View 10 Replies
View Related
Oct 24, 2005
I would like to welcome the users at login on my db,
I have a table that list user details which has the following fields
tblUserDetails
UserID
UserName
Password (encrypted)
UserLevelID
FirstName
LastName
EmailAddress
What I am trying to achieve is after logging in, I would have a welcome $User$ on the splash form/switchboard
So to re-cap, I would like some kinda vba coded example that will ref [FirstName]
Thanks in advance
View 2 Replies
View Related
Dec 28, 2006
Hi,
I want to write the code to detect that whether or not the administrator assign current user to access the database in SQL Server.
How can i detect it?
Suppose I have a database db1 in SQL Server, we assign the username to specific database. And then I linked tables from SQL Server to MS Access
When the user open the MS Access, I want the program to detect whether or not the current user has his/her name in the database from SQL Server.
How can i do that?
I just know to use is_member function, but this one is detecting user role, I want to detect whether or not administrator assign the username to the specific database from SQL Server.
Please let me know about it.
Thanks.
View 3 Replies
View Related
Aug 12, 2005
Is there a way in which to assign user permissions to vba code?
I have some command buttons which run vba code but i only want to allow certain users to use these.
View 7 Replies
View Related
Sep 20, 2005
Hello all. This is my first post on here after reading many of the other threads as I try - often in vain - to pick up access.
I am in the process of building a couple of databases, the main one being one that is an amalgamation of 4 other/older mdb's. All tables/queries etc were simply imported from these older defunct mdb's and then are archived off every month so they have 3months data and no more in them. The only thing is when it comes to problem solving and/or new queries, it is impossible to tell which tables/queries relate to which sections of the Db.
So my question to you is can I rename tables and queries in any way so that any queries that are using these tables are updated at the sametime, and if so how is it done? I have asked my colleague who is working with me to develope my understanding of access and he is at a loss. We are in the process of trying the old fashioned way ..... getting a book from the libarary ... but thought I'd try this new fangled internet thingy first :D .
The thought of having to trawl through around 100 tables and queries to rename or even re write the entire query/formulae is so daunting, I simply dont have that amount of time. Im using Access 97 and would greatly appreciate any help on this.
Thanx
View 2 Replies
View Related
Sep 27, 2005
I have finished the database application, and now want to make a user login for specific users to run the application (but not to change the internal desgin or data).
How can it be done ?
Do I need to split the database first before doing that ? :confused:
View 1 Replies
View Related
Oct 21, 2005
Hello,
I'm a pretty new user to Access. What little experience I have is from directly playing around with sample databases. Currently I'm helping a small non-profit organization here with data management.
My question is, are there any simple ways to create a sort of alert or scheduled notification based on the current date and some trigger criteria. Basically when a client enters the program, we input a load of data on them manually. And periodically we have to check back with them for stuff such as 6 month testing, X/hours testing, monthly checks etc.
Idealy I'd like to set up something that would start when the database is opened and alert any volunteer or staff person that soandso people need to be called to do soandso.
Macros? Reports? I have no idea where to begin.
Sorry in advance if this is one of those obvious answer questions. I find access intimidating sometimes, especially when so much information is in there thats vital to our program.
Thanks for any suggestions!
View 2 Replies
View Related
Oct 28, 2005
Hi,
I found this database with an LOGIN sample.
This is working perfectly...(see example)
Now I want to accomplish this:
Based on the user that is logged in I want to generate reports.
Is there a way to recall the username or userID and link that to specific reports...
Allso I want to add an mail adress field in the userstable and based on the logged in user I want to hit a mail button and it will check the logged in user...
and mail the report to that specific user...
Can someone help me?
Thanks,
View 3 Replies
View Related
Dec 16, 2005
I have successfully created a user id & password prompt which works excellently.
The database i have created has three forms inwhich two departments access. I have an issue where one department is only allowed to view a search screen and the other department is allowed to enter in information and search. I also have a section for managers to login and run reports.
In my userid & password table i have created and field called Level which includes: Administrator, Manager, Bookings,User
Admin - Full Access
Managers - Full Access - But not able to edit queries and tables
Bookings - Order Form, Search Form
User - Search Form
Here is the code i have used:
Login OK Button:-
Private Sub login_Click()
If txtPassword.Value = DLookup("Password", "tblAccess", "[UserId] = txtUser.Value") Then
CheckFlag
DoCmd.Close acForm, "frmUserLogon"
Else
MsgBox "INCORRECT PASSWORD! Please try again"
End If
End Sub
Module1:
Option Compare Database
Public Flag As Integer '1: Reports Opener 2:Log 3:OpenUKSupplier
Function CheckFlag()
Select Case Flag
Case 1
DoCmd.OpenForm "frmReports Menu"
Case 2
DoCmd.OpenForm "frmbooking"
Case 3
DoCmd.OpenForm "Frmsearch"
Case Else
'Should never be here
End Select
End Function
Where would i add the code to the module or to the event?
View 4 Replies
View Related
Jan 24, 2006
Has anyone got an idea on how to issue user rights i.e. one person can write to a certain table whilst another can only read the same table. Ive had a good search but unable to find anything! If anyone has a good thread or website I would be most grateful!
View 1 Replies
View Related
