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 Replies
ADVERTISEMENT
Jun 13, 2006
how can i password protect a form?
i want a have a button that on click will ask for the password. if the password is correct then proceed to open the for else tell them they are not authorized.
i know i would need an if statement but thats as far as i got..
can some one provide me with some sample code?
thanks
View 4 Replies
View Related
Aug 30, 2005
Hi
I've got a button on a form that opens another form - nothing unusual, but it would be preferable if this second form was password protected i.e. the user clicks the button to open the form and is immediately prompted to enter a password. I've looked at user-level security wizards but that confused me even more.
The database is networked and is used by 25+ people by the way.
Any ideas?
Thanks for any help!
View 2 Replies
View Related
Mar 2, 2007
I managed to password protect my backend (as the backend is on a server and anybody could access it) so i have it password protected so only i can gain access to the data.
Now, when i try and access the backend from the front end, the frontend prompts me that the password is invalid (indicating its trying to enter the backend using no password, thus an invalid password warning appears. And this means nobody can access the data from the frontend)
Is there a way to get round this password issue from the frontend? I.e. have the password for the backend, but when you access the frontend, it doesnt need the password for the backend (i have my own username/password system to log on to my database)
I know there are different user level securities you can use, but im not familiar with this. So if you have an idea about this, then im all ears but keep in mind I don’t really know how the security levels work in Access (nor do i have the time to learn it in depth or even find help other than here)
Many thanks for your help
David
View 4 Replies
View Related
Jan 30, 2008
HI,
I have a MS access 2003 database (in MDB format) which I use as a basic accounts system for our company (15 user). I have certain tables password protected depending on user using the old workgroup information file. This presents a problem as anyone can copy the database without linking the Information file and effectively get full admin access. I was looking to upgrade to Access 2007 but I gather that there is a different security engine and also a new file format (accdb file). I know that you can keep the same user security settings when upgrading to 2007 (while keerping the mdp file extension) but would be interested to know if I can improve security using 2007 while also being able to retain user-level access to certain tables like in access 2003? The major weakness in my system at the moment is anybody can copy the MDB file to another PC and access everyting...it seems too easy a system to crack. Do I need to completely reprogram my database using MySql on MSSql? Any advice would be appreciated?
Thanks in advance,
Shane
View 2 Replies
View Related
Jun 16, 2006
I have a set of tables, one of which contains sensitive information, which i need to password protect.
I've been through the User Lever Security Wizard a few times but i can't seem to find a security group account which will allow data to be input into a form but also to deny access to the afore mentioned table.
Can anyone help?
View 1 Replies
View Related
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
Nov 11, 2004
Hey Guys, I have a whole login system that I have created in asp. Now I am trying to make it more secure, and to also let the user modify settings or retrieve forgotten login information. I am getting the following errors:
changedpassword.asp - http://www.nuflowtech.com/logintesting/members.asp
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/logintesting/scripts/changedpassword.asp, line 31
memberscheck1.asp - http://www.nuflowtech.com/logintesting/members1.asp
Microsoft JET Database Engine error '80040e4d'
Not a valid password.
/logintesting/scripts/memberscheck1.asp, line 31
The pages are attached. If anyone could point me in the right direction as to what is wrong with the codes, I would apprecaite it. Thank you all for your help.
-JC
View 2 Replies
View Related
Aug 17, 2006
Hi,
Basically i have a single database with several tables in it. I want certain tables such as Ireland, UK, US etc to only be accessable by employees from those countries. Is this possible and if so, how?
I have looked at user/group permissions but can't figure out how to assign passwords to users etc.
Any help is much appreciated
Thanks
Scott
View 2 Replies
View Related
Feb 7, 2006
I have a combobox on a form which is populated from a field to present a list for the user to choose from.
I have limit list set to 'N'
When the user types something in the combobox that is not in the field in the table then I want to prompt for a password. Effectively password protecting the update of the field from a combobox.
If the password is correct the text is written to the field in the table and if not then not.
Help ?
View 9 Replies
View Related
Jul 22, 2005
I was using this form tutorial to password protect my administrative tools. When I went to run it I received this:
"User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted.
I have little experience with VB and I was wondering if someone here had any idea if it was their code that was wrong, or if it was something I did...
View 7 Replies
View Related
Mar 29, 2007
I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'
I must obviously be doing something wrong, can anyone help?
View 4 Replies
View Related
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
Sep 12, 2006
hi pals
i have set username and password for ms access file.
unfortunately i have forget that password?
how to crack that username and passowrd?
is there any softwares available?
i can easily crack the database pasword? but how to crack username and password of ms access file.
View 1 Replies
View Related
Aug 7, 2015
Access 2007 / I'm creating a database form that has a combo box drop down pulling EmployeeName and a free text field to enter a password. I need the password entry validated against the password stored in a column on the same row as the Employee Name selected from the combo box when a button is clicked. . IF, that value is validated, I need the button click to also record a "time in" or "clock in" entry in a different table.how to validate the password.
View 3 Replies
View Related
Jun 29, 2006
Hi all,
Need help urgently!
Need to know how to make the password field in table alphanumeric?
should i set in form or table?
thanks alot~!!!
View 1 Replies
View Related
Apr 4, 2008
hi, i am currently working on a computing project using access 2003, and i am not very familiar with VBA.
At the moment, i have designed a simple logging-in form (with a function that checks the password typed in for a username (selected from a combo box) against the password value stored in a table
Is there a function in visual basic access where each time a user logs in, the date (and date) is recorded into the table where the user details and passwords are stored?
help would be much appreciated
View 2 Replies
View Related
Sep 24, 2013
How to validate a MS Access password text box as criterion below?
(i) At least one uppercase
(ii) At least one lowercase
(iii) At least one number
(iv) Password length 8 - 12
View 1 Replies
View Related
Sep 18, 2006
Hi,
I need some help creating a way for two different type of users to be redirected to different forms after entering a password.
I tried using the groups security in access but it's not good.
What I need the program to do is:
ask the user to enter a password. then if the password is correct and they are managers they will see the managers opening form ("form1") and if they are employees they will se a different opening form("form2") with less options and different reports.
thanks.
View 4 Replies
View Related
May 22, 2014
I have a query that I am sending as a spreadsheet to various service technicians listing parts that they need to take inventory of. Then, after they take the inventory, they send the spreadsheet back to me and I upload their counts back into my database. Right now, my query contains the Bin number, part number, part description, and a blank column for the technician's count. I have just learned, that the company does not want the Bin number to be visible in the report. In order to upload the technician counts into the database when they return the spreadsheet, I need to be able to reference the Bin number to get the count on the right line.
Is there something that I can do so that the Bin number will be visible in the report when the database reads it, but not to the technician?
The only solution I could think of was to format the Bin Number as a password. Unfortunately, I can't get that to work in the query results. If I save the bin number as a password in the table, is there a way to make it visible on reports for internal use (so the people in headquarters who are responsible for over all inventory can still see each bin number)? I found how to hide the field in the query results. However, when I send the results to the technician, the field is not there at all.
View 5 Replies
View Related
Jun 10, 2014
How can I generate a random string to a text field from a button. I
Say I have a form..
On the form I have:
X1 Button (BTN-Generate-Password)
X1 Text Field (TF-Generated-Password)
How can I make it so when the button is clicked a random string will appear in the text box
HTML Code:
Private Sub BTN-Generate-Password_Click()
(What Do I put here?) (Will it populate the Text Field?)
End Sub
- 9 Characters
- Upper and Lower Case
- Numeric & Alpha Numeric
- These Characters (!@#$%)
View 1 Replies
View Related
Oct 18, 2005
I have created a login form, with a user name and password. It works great. However I need to use the login form for three different command buttons, on my main access form. The same login form will be used but It will need to open three different forms depending on what command button was selected on the main page.
Main page- PID
3 command buttons- building, documents, assessments
login form- login
3 documents- build, docs,assess
I open main page, PID- click on buildings the login form pops up and I enter the correct username and password the building doc opens. Got it?? The same process for each, I would like to know how is this possible? How do I change the differnt documet that opends according to the command button that has been pushed? :confused: Thanks in advance
View 10 Replies
View Related
Mar 18, 2005
I have set up a front screen which has linked buttons to other forms.
When I open up some of the forms (using the buttons) I would like them to be password protected.
I know tihs is probably really easy, but I cant get it sussed!!
Any help would be appreciated.
thank you
Mojaveboy
View 2 Replies
View Related
Jan 6, 2014
I am looking to ensure the user enters a complex password, in the add user form. Therefore, the password should be >8 characters, 2 numbers, 1 Ucase min, 1 Lcase min and some form of punctuation. I found this code:
unction ValidatePassword(ByVal pwd As String,
Optional ByVal minLength As Integer = 8,
Optional ByVal numUpper As Integer = 2,
Optional ByVal numLower As Integer = 2,
Optional ByVal numNumbers As Integer = 2,
Optional ByVal numSpecial As Integer = 2) As Boolean
[Code] ....
but obviously this doesn't work in access. How can i either change it to work for microsoft access, or how would i go about developing it. What would the code be?
View 5 Replies
View Related
Sep 9, 2013
I have written the following code on a command button to set up a basic password for deleting current record. What I really want to do is hide the password being typed into the input box with asterix's. Here is the current code and password:
Private Sub Toggle33_Click()
Dim strPasswd
strPasswd = InputBox("Enter Password", "Restricted Form")
If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
[Code] ....
View 5 Replies
View Related
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 14 Replies
View Related
