Forms :: Log-in Database Username And Password

Nov 2, 2014

I have an error message or debug message in my code in username & password log in.. it has an error in if else statement

empname is a cobobox
empass is a txtbox
logempID is a autonum I.D
usrnmpass is a table name

there's an specific record in a table of usrnmpass showing in the attachment

this is my code....

Private Sub Command1_Click()
If IsNull(empname) Or empname = "" Then
MsgBox "You must enter a User Name.", vbOKOnly, "Required Data"
empname.SetFocus
Exit Sub
End If

[code]....

View Replies


ADVERTISEMENT

Forms :: Username And Password For Database - Login Form?

Apr 8, 2014

I would like to implement a login form to my DB.

I have a table db-users with three fields: empID; empName; empPassword

I have a form with an unbound combo box: cmbdbUserName
And I have a text box: txtPassword where the user will type in their password.

cmdDBLogin is the button I want to add the VBA code to on click.

Code that will compare the inputs of the two objects listed above to the data in the table fields listed above that?

View 11 Replies View Related

Password/Username Help

Sep 26, 2004

I created a password for my database and now I cannot access it. The dialog box says that either the username or password may be incorrect. I do not know what the requested username is. I do not recall creating a username during the process of creating the password. I do not know what username ACCESS is asking for. I think I know what the password is. I think the problem is the username. However, if I somehow do not know the password, what can I do?

After you finish laughing at me, please help. Thanks for any assistance you can provide.

View 1 Replies View Related

Username And Password

Aug 10, 2006

I want to secure my Access database with a username and password. I want to be able to pull the nt login of the user and have them access only the things i need them to access. How can I do this?

View 4 Replies View Related

Username & Password

Sep 25, 2007

Hi,

i have an access db which i want to protect with various usernames & passwords how do i go about this?

View 3 Replies View Related

Username & Password Woes!

Jan 10, 2007

Hello!
I have a problem regarding using usernames and passwords to restrict access to certain tables/forms/reports etc....
I have read around the forum and various other websites but cant seem to get much relating to exactly what i am wanting to do.

I think i understand the way the access workgroup security works. But does this not just restrict users being able to view the database as read-only or with other certain rights like that? So, firstly would i be able to use this to restrict the database the way i want?

Or is there a way to create a table with names and passwords and create a form at the beginning where the user inputs their details and then according to the details gives/restricts access to parts of the database? Ideally i'd like the startup form to direct them to a different menu according to the user which gives them only the options they are allowed?

Seems a bit of a mouthfull and i sound like a complete newb but i been trying to figure this out all day!!
Thanks

View 2 Replies View Related

Access Doesn't Ask For Username And Password

Jun 23, 2006

I created security using the security wizards, separating admins vs. data entry users. I gave everyone a username and a password but when I reenter the database it doesn't ask me for my username or password. Does anyone know why or how can I fix it?

View 2 Replies View Related

Create Username And Password Promt?

Sep 17, 2004

Hello,

I was wondering if it were possible to make a msg box pop up when opening a database asking for a user name and password. And that will be the only way to enter the database.

Thanks

View 2 Replies View Related

Sign In To Access Using Username And Password

Oct 19, 2014

I want to create a user name and password in to access my data base

View 3 Replies View Related

Modules & VBA :: Validate Username And Password In A Button?

Jan 20, 2014

I would like to ask how can i validate the username and password in a textbox? I have a frmLogin and frmMain.

I have also a table called 'tblUsers' with column fields 'username and password'.

If username is not found in database then a msgbox will prompt 'Username is not yet created'.

If username is okay and password is incorrect then msgbox will prompt 'Incorrect password'

If username and password is okay, then a msgbox will prompt 'Successfully login' and will continue to frmMain.

View 3 Replies View Related

Login Username Password Open Form Based On Id

Sep 13, 2006

Hi Freinds,

After viewing all the threads i got some useful information but just wanted some help as i am not a programmer but can understand logics. There are 2 issues i want to resolve

1. First query is i have a login form and in a table there is username password. Now issue is based on the username person should be able to view things. There would be 6 differrent departments. So i would have six users and 1 id only for viewing. These six users should be able to see there own records either assigned to them or create new query and assign to any other 5 users. Now option is either I create six replicated forms and based on the user login i open user form or switch board. Can there be any option where in a table i store the activities they can do and whereever these guys go the code check in table and enable or disable the view of items for other guys. Users would be accessing forms, reports and they would have option of entering cusotmer information and querying and changing information. The user which has option of viewing reports will only have option of seeing some customized reports.

2. Second query is that these six users would be addressing issues to each other regarding cusotmer issue. In this every response of the case should be stored in a table. i.e. like for customer x user1 said abc on 10th then user2 said cbf on 11th. so this would have history of case what was happeining in the matter.

I dont know how to go about this and if there is a easy solution. I dont want to use access security cause then all the six users would have security file.

Would apreciate your help and till now whatever responses i have seen in other forms they were quite helpful and did help me lot in understanding access.

Thanks to all who would be visiting this thread and taking pain in answering the query.

Take care
Ankur

View 3 Replies View Related

Prompt For Password And Username Each Time While Pressing Cmd Button

Jan 23, 2007

Being dealing with my database and having quite some trouble with it. Is it possible to track down what the users did, during the time they login into, database, is it possible to prompt users for password and username when they buttons for like, delete cmd, or update command.

Just a breif idea on what im trying to do.(hopefully it won't confused you all)
Im trying to created a 2 main username. One is for admin group and another is for users group. Then users can login in to database, however whenever the users update or delete entries in the database, the user will prompt for their username and password (not the users group login ). Is it possible to build a table to store in the username and password for the prompting purposes one.

Sorry for confusing question. Actually im trying to think of another way, but for now this complicated event all i have think of. Feel free to voice your suggestion here. Thanks alot. TQ

View 4 Replies View Related

Identifying Form - Check Username And Password Of A User

Jan 15, 2015

How to make a form that must Check the username and password of a user, in case if they are true then let the user to visit other forms and Tables...

View 1 Replies View Related

Password Issues With Non Protected Database Asking For Password

Nov 8, 2005

Hi,

Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.

I have an Access Db that is not password protected, but is asking for a password.
It opens on any other machine fine?

I think my version of Access is playing funny buggers with me, any suggestions?

I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.

Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??

Your help on this obvious pointer would be great!

C

View 3 Replies View Related

Forms :: Password Protecting Field With Password?

Oct 24, 2014

i have found a code that brings up a box when tab or clicking in to a box for editing as below:-

Dim strPassword As String
If InputBox("Please enter the password:") <> strPassword Then
SomeOtherControl.SetFocus
TextBox1.Locked = True
End If

its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.

View 4 Replies View Related

Forms :: Extract First Name From Username For Welcome Screen?

Apr 9, 2014

I have a module that pulls the user name in the firstname.lastname format. This is the module (module name is fosUserName):

Code:

Public Function GetUser() As String
Dim WNet As Object
Set WNet = CreateObject("WScript.Network")
GetUser = WNet.UserName
End Function

I what to add a a text box on the welcome screen that says something along the lines of Welcome firstname (from the firstname.lastname that the code above pulls) what would you like to do? I need some code that will get me all the characters left of the period that separates the firstname from the lastname.

View 4 Replies View Related

Forms :: Combo Record Selector Using Either ID Or Username

Jul 19, 2013

My problem is related to an Access database, where an auto complete Combo box is used to select a client record by entering the ID number or the clients name. EG: 14034 or Bloggs,Fred. This problem has me puzzled (not difficult to do).I have seen this in a functioning DB. I can see that maybe the ID (a long integer) would have to be stored or converted to a string on the fly.

I am currently using Access 2007 but 2010 and 2013 are available (prefer 2007 as MS keep moving things around ).I am currently selecting a client record using either an ID select Combo or a ClientName Combo and works very well. But, after seeing it done in one Combo box, it just seems so elegant.

View 1 Replies View Related

Forms :: Adding Windows Username In New Record?

Nov 1, 2013

I am having a difficult time figuring out how to have a table add a new record that includes the Windows username of the user that clicks the button on my form. The function is in place that pulls the Windows username:

Code:
Public Function getWinUser() As String
getWinUser = Environ("UserName")
End Function

I then call the function during the button click by simply adding getWinUser. Unfortunately, all that occurs is that the same record gets updated instead of creating a new record.

View 14 Replies View Related

Join Database With Password

Jan 3, 2006

Hi, I have the SQL query below where I am JOINing two tables for two different databases. Both databases are password protected.

Query from MS Access
SELECT T2.cl_ser_id AS Expr1, T2.cl_idno AS Expr2, T2.cl_name AS Expr3, T2.cl_surname AS Expr4, TL.SiteRef, TL.Date, TL.Time, FROM [db2.mdb].tablenames AS T2, [db1.mdb].TransactionLog AS TL

My problem is accessing the second database from the first one.

db2.mdb is password protected !


If I remove the password from the second database.. the query works perfectly. Although due to security reasons, both databases must be password prtected.

Thank you for your help.. as always :D

View 2 Replies View Related

Database Password Issues

Mar 30, 2006

This is technically not about Access I suppose, it's about an application called Simply Accounting, which uses the Jet Database engine. Please bear with me, because the expertise for Simply seems to be mainly about Accounting and not the the tech side.

If your not familiar with Simply Accounting ( SA from now on in this post ), it keeps its data in an .SDB file, which I gather is a renamed .mdb and it's security information in an .SDW file. An .LDB file pops up when users open the database, and disappears when the database closes. Sound familiar?

I'm trying to gather some information on how this security system works, as I have only an acquaintance with databases.

Basically my problem is that I have a SA database with 2 users, both of whom can log in to the DB independently but not concurrently. The database resides on one of the users computers, and the other accesses it from the network.

Environment:
2XP Pro WS, MSOffice, MSWorks, Simply Accounting, Avast, AluriaAntispyware.Peer to Peer LAN.
Identical User Accounts and Passwords on both PC's, ie User1 has the same UID and PW on both computers as does User2.

The problem:
User1 on PC1 can open database in single user or muli-user mode. If User2 on PC2 attempts to login and open database while User1 is has it open, User2 get a bad username/password error.

However if User1 on PC1 logs off, User2 on PC2 can open the database (which resides on PC1 ) successfully.

This worked well on their previous LAN on their old gnarly slow spyware infested computers, however on the new computers it does not work. Inf act if I move a copy of the DB over the old computer, multiuser use works perfectly.

I'm thinking it has to do with the way tyhe password files work...something to do with SIDs maybe...like maybe if users are connecting concurrently, the fact they are presenting SIDS from 2 different machines is screwing things up?

Perhaps the database is comparing SID from WS1 with SID from WS2 when User2 on WS2 tries to connect, and seeing they are different thinks it's a different person?

Anyway, if you know something about this, please please let me know

Thanks

Len
e-pni
www.e-pni.com

View 1 Replies View Related

How To Set Password To Ms Access Database

Sep 10, 2006

hi pals

i am newbie to msaccess. i want to set password to msaccess database file.

how to do this?

View 1 Replies View Related

Database Prompts For Password When None Is Set

Oct 9, 2007

I am having a problem with a database. On one particular computer, a user tries to save data into a current database. The database prompts the user for a password. No password is set on the database. From what I have gathered from searching the internet, it appears that the database would be corrupt, but not so fast. About 20 other people use the same database and have no problems entering data into it without getting a password prompt. Even the same user that is having problems can enter data into the database from another PC, it is only this one PC that it is prompting the user for a password. Has anyone else experienced this problem and what can I do to fix this issue without re-imaging the PC? Thanks.

View 3 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Moving Password Protected Database

Dec 28, 2006

Hi Everyone,
I am attempting to move a password protected database to a different folder on our shared drive but I am not sure the steps that are needed to do so. The database is already split. Can someone please assist???

View 3 Replies View Related

Help With Password-protecting Database For Edits

Jun 6, 2007

Hello,

I designed and distributed a database client to a bunch of users. They have asked me to password-protect it so that anyone can open the database and view the forms, but a password is needed to actually make any updates. I am trying to do this, but everything in Tools--Security is making my head spin. I have actually already managed to somehow lock myself out of my own database, although I have another copy.

How do I set the Workgroup Administrator Files so that they apply to anyone? It wants to put a separate file on my C: drive, but I don't use this database, I distribute it to people who do. (The server is on a share drive, can I put the Workgroup file(s) there?)

What settings do I modify to require *anyone* to need a password to update? Or is that even possible? I don't really want to break up the users into different categories.

If anyone could walk me through this process I would really, really appreciate it.

View 6 Replies View Related

Open A Password Protected Database

Jun 22, 2007

Hi,
I'm trying to convert a access database in to a sql server. My client hasn't got the exclusive access or doesn't have a username password for the access database. I'm trying to import the data in the access to sql server and when I try to open it it says
"
This error is usually associated with opening or converting a security enhanced Access 97 or earlier database. If you are not the owner of the database, you most likely will not have the necessary access rights to open or convert it.
"

Is there a way around this.

Cheers,
-Vije

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved