General :: MS Access Password Field Validation
Sep 24, 2013How 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
ADVERTISEMENT
Password Validation
Jul 18, 2006Came across this and modified it so that it checks if the password entered has at least one number or symbol.
(a function to be placed in a global module not macro)
Code:Function IsAlphaNumeric(strTest) As Boolean'IsAlphaNumeric used to test if a string has a number or a symbol in addition to regular alpha characters.'What it does it take an input string and converts each character of the string into its corresponding ASCII code (uses the VBA function Asc()).'The function then checks the ASCII value of each character and adds one to count if the character was a number or symbol.'The function also checks the ASCII value of each character and adds one to count2 if the character was a regular alpha character.'Finally the function checks to see if count and count2 are both greater then 0, if it is then the string has a number or a symbol in addition to regular alpha characters.Dim Char As StringDim CharNum As IntegerDim i As IntegerDim count As IntegerDim count2 As Integercount = 0count2 = 0 For i = 1 To Len(strTest) Char = Mid(strTest, i, 1) CharNum = Asc(Char) '48-57 is the ASCII range for 1-0, the other values are for the following symbols ~ ! @ # $ % ^ & * ( ) ` If (CharNum > 47 And CharNum < 58) Or (CharNum = 33) Or _ (CharNum > 34 And CharNum < 39) Or (CharNum > 39 And CharNum < 43) Or _ (CharNum = 64) Or (CharNum = 94) Or (CharNum = 96) Or (CharNum = 126) Then count = count + 1 End If '65-90 is the ASCII range for A-Z, 97-122 is the ASCII range for a-z If (CharNum > 64 And CharNum < 91) Or (CharNum > 96 And CharNum < 123) Then count2 = count2 + 1 End If Next i If count > 0 And count2 > 0 Then IsAlphaNumeric = True Else IsAlphaNumeric = False End If End Function
I use it when the user wants to change the password for the local front end db. It makes sure that the user has to have a password at least six characters in length and must have a symbol or letter.
Code: If newpass = Me.currpw.value Then MsgBox "Password cannot be updated. Please make sure the new password is different from the original password", vbExclamation, "Password update FAILED!" Exit Sub End If If Not newpass = Me.confrimpw.value Then MsgBox "Password cannot be updated. Passwords do not match, please make sure to re-enter the new password twice.", vbExclamation, "Password update FAILED!" Exit Sub End If If Len(newpass) > 6 And IsAlphaNumeric(newpass) Then 'Update current user's password DoCmd.RunSQL ("UPDATE Users SET [strEmpPassword] = '" & newpass & "' WHERE [lngEmpID] = lngMyEmpID;") MsgBox "Password has been updated ", vbInformation, "Password updated!"
With this you can expand it so that if you want the user’s new password to have at least one number and one symbol
One thing I am not sure about is to make sure the password is a strong password and not a weak one. I was thinking of having it subtract the ASCII code of every two characters and if there value is 2 or less add one to a general count variable, then divide that general count variable by the number of iterations and check to see if that value is 2 or less if so then it’s a weak password, not sure if that makes sense, any ideas?
General :: MS Access 2010 Cannot Remove Password
Apr 23, 2014I have MS Access 2010. I cant remove password because when I open in exclusive mode, file, info, there is no decrypt password option.
View 1 Replies View RelatedGeneral :: Possible To Password Protect Access To Source Code?
Jun 10, 2012I've been working on a large project for my employer for a year now (but software development isn't part of my normal day to day duties). Most of the work (around 70%) has been done in my own time at home. The company were going to buy a system that would be customized by developers at a cost of around $60,000. I've developed a solution that is probably better than what they would have got. At my last appraisal my boss said that it had been discussed that i would be rewarded if i delivered it. My question is:
Is it possible to password protect access to the source code? I'm working with Access 2003 just now. I know I can create a .mde file to prevent access to the source code but that would make further development difficult. e.
General :: Open MS Access Database Locked By Password?
Mar 22, 2013I have MS access database. The database is password encrypted. I do not own this database but it is critical for me to see the contens of this database. I do not want to edit the contents.
View 9 Replies View RelatedGeneral :: Multiple Users In Access Each With Unique ID And Password
May 29, 2015I already have created & run an Access database for around 12 users. I now am looking to create a database that can have at least 30 users. Each one with a unique user ID & password (Using a security file ".mdw") Users log into a front end on a network environment. Now...My question...Is 30 to large of a user base for Access in a network environment??
View 6 Replies View RelatedForms :: Complex Password Validation
Jan 6, 2014I 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?
General :: MS Access 2010 - Prompt To Enter Password On Closing Database
Nov 19, 2013I do not have a split db. I am prompted to enter my password when the db opens which is fine. However, when I close the db it prompts me to enter a password (not normal) and when I enter it it says invalid password. Also, when I try to change my password it says invalid password and when I try to compact and repair my db it say invalid password.
View 1 Replies View RelatedGeneral :: Access 2007 Validation Taking Minutes?
Dec 12, 2012Everytime I close, open, modify, etc, you get my drift,either a linked table or an in database table, Access validation takes minutes before I can continue.
What can I do to reduce this time or process?
Forms :: Password Validation - Message Pop Up With Specific Error User Has Made On Entry
Jan 6, 2014I am looking at the public function routine, that validates the password entry. I want to know how i can make a message pop up with the specific error the user has made on entry.
Public Function ValidatePwd(varPassword As Variant) As Boolean
Dim blnValid As Boolean
Dim blnValidCriteria As Boolean
Dim intChar As Integer
blnValid = Len("" & varPassword) >= 4 And Len("" & varPassword) <= 12
[Code] ....
Forms :: Password Protecting Field With Password?
Oct 24, 2014i 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.
Access Newbie Question - Field Validation
Apr 9, 2008I’m trying to create a DB with some field validations. I have a field named ‘Value’ and a field named ‘Doubled’. Value is in a currency format. ‘Doubled’ is in a Y/N format. I want a to create a rule that prevents the value ‘Yes’ from being entered in the ‘Doubled’ field IF the value in the ‘Value’ field is greater than .60. How do I do that?
I entered "[Value]< .6" but that wouldn’t allow me to put any value in the ‘Value’ field – it popped an error every time.
Thanks for helping out a newbie!
How To Crack Ms Access Password, I Have Set User Name And Password
Sep 12, 2006hi 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.
General :: Getting Rid Of Password On Opening All Database
Jul 11, 2014I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all. I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.
View 9 Replies View RelatedGeneral :: Not A Valid Password Error
Jul 23, 2012I am trying to link some tables to my front end and the tables are within an encrypted and password protected database.
When I link the tables, it asks me for the passwork which I enter and the tables do get linked to the fron end..
However when I try to attach the table to a combo box or try to open the tables I get a message which says "Not a Valid Password"
So it does allow me to link the tables with the required password but when I try to open the linked tables it gives me the above error.
I am using Access 2010..
General :: Not A Valid Account Name Or Password
Apr 7, 2013It seems I've overstepped in setting up Users and Permissions, in MS Access 2007, on an .mdb. When I enter any of the user names and passwords I've created, I'm told that it's not a valid account name or password. I'm wondering how this could be possible since I'm staring at them in the Snapshot file.
My question is this: I can access the .mdw file as "Admin", is there anyway to unwind this mess?
General :: Unable To Set Password - Open Dialog Box
Mar 2, 2015When trying to set a password I receive the following message.
You must have the database open for exclusive use to set or remove the database password.
To open the database exclusively, close the database, and then reopen it by clicking the File tab and using the Open command, In the Open dialog box, click the arrow next to the Open button and then select Open Exclusive.
When I follow the instructions, I don't get a dialog box. How do I set a password?
General :: Open Read Only / Password To Modify
May 6, 2014OK, I tried to see if this was possible but not finding much of an answer. So I figured I'd check with our merry band of experts if it even is.
I'm using Access 2013 and I have a database I would like everyone to be able to see but only those that have a password to be able to change data.
Is there a way to even to do this? A code somewhere maybe?
I've been able to find the option to make the whole database password protected but that's not what I'm looking for.
General :: Deploying A Password Protected Backend
Sep 23, 2013I have to do this and I believe there is VBA code to re-link tables when needed that can be found on the web. My client needs access to everything because he will move on to another developer after this, so what I thought I would do is send him a private file that has the password for the backend and then just write the ADO code needed in the app's front end to connect with the password.
View 2 Replies View RelatedGeneral :: Change Password For Back-end Database
Jul 22, 2015I need to change the password to the front end of my split database. How would I do this?
View 1 Replies View RelatedGeneral :: Database (ACCDB) Password Recovery
Feb 6, 2015I need to recover a database password (.accdb). How or is there any good software password recovery out there?
View 7 Replies View RelatedHow To Access Ms-Access WorkGroup Tables To Change Database Login Password
Apr 13, 2007Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.
Regards,
Kishore
General :: Set Password For Tables And Forms - Allow Admin View Only
Apr 21, 2013I have a receptionist which uses a database that contains everything in the company ..there is an employee table that contains their salaries and I want to set password for this table so that the admin is the only person who can view this table .......... is that possible?? And the same thing for a form that controls this table!
View 4 Replies View RelatedGeneral :: Creating Password Protection On Specific Tables?
Sep 20, 2012I would like to know if I can create a password protection on specific tables. Within my database, there are certain tables and/or reports to be view by a selective amount of personnel. Can I password protect just that view?
View 2 Replies View RelatedGeneral :: How To Apply Validation Rule
Nov 15, 2012I have a text box that the user enters a number into between 1 and 5. I can use the validation rule in the table and that works nicely, the trouble is that I don't want the standard Access message box.how to apply the validation rules.
View 8 Replies View RelatedGeneral :: Database Redundancy And Validation
Aug 16, 2013I've inherited a database with multiple users, massive redundancies, and strict policy limitations:
1. The existing table structures must remain, despite redundancies that create problems constantly, because of multiple client programs.
2. Data entry must not be programmatic: no data can be generated by code.
I can, however,
A. Create new, interdependent tables, or
B. Validate data with criteria or VBA.
I have two rules I'd like to enforce:
Rule 1: This one is easy. Certain redundant Locations must be identical. So, all the Locations in Table A must appear in Table B as well (although B may contain Locations not in A). No Big Deal.
Rule 2: An absolute rule for every Location is that each must occur between the boundaries established for that particular Track and Section.
So, given that I have a Table with Records of Track, Section, StartLocation, EndLocation (which defines the limits for Location values)...
Track 1, Section 1: Starts at Location -100, Ends at Location 100
Track 1, Section 2: Starts at Location 50, Ends at Location 20
Track 2, Section 3: Starts at Location 0, Ends at Location 400
I want to prevent users from entering illegal locations in another Table with Track, Section, Location, like:Track 1, Section 1, Location 101 (this location is beyond the end of Track 1 Section 1)I could code this in VBA, but the downside is it won't be enforced if the user has Macros turned off by default.