Password Masking
Apr 16, 2005
Hi Gurus.. :D
Need some wisdom.. ;) I got code behind buttons on my main switchboard form to enable passwords on the buttons.. I use the following code...
Private Sub Option2_Click()
On Error GoTo Err_Option2_Click
Dim stDocName As String
Dim stLinkCriteria As String
Dim Password1
Password1 = InputBox("Please Type the Password", "Password Prompt")
If Password1 = "password" Then
stDocName = "Main Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Else
End If
Exit Sub
Exit_Option2_Click:
Exit Sub
Err_Option2_Click:
MsgBox Err.Description
Resume Exit_Option2_Click
End Sub
My issue is that I need to mask the password, I know if it can be done by other methods, such as creating an inputbox on main form and setting the input mask property to Password and useing the button to make this visible.. etc.. However, a little bit of a mess.. the above code is simple and straight forward.. Is there any VB code that I can enter for an input mask for the inputbox :confused:
Hope you can help.. Thanks.. :D
View Replies
ADVERTISEMENT
Feb 25, 2007
Would anyone know if it is possible to mask and input box with a password mask (*****)
my code is simple:
StrPswd = InputBox("Enter Password", "ENTER PASSWORD")
I was trying to mask the entry in ****** when the user enters the password.
Any ideas ??
Thanks
View 2 Replies
View Related
Jul 21, 2006
Hi,
I have a text box where users input a person name as it appears on their bank account. This text box can only take alpha characters and no numbers or other characters except the "&" sign.
Please can some one help in to how i can mask this text box to only take text and nothing else, not even a combination of text and numbers can be accepted, please help!
Thanks in advanced!
View 1 Replies
View Related
Jun 7, 2006
I have a form based on a table where social security numbers are entered. I would like to enter a social security number on the form and once it's entered the first 5 digits are masked. When I go to the table I would like to see the complete social security number displayed. Is this possible? Can the control source on the form be formatted to hide the existing social security numbers as well so they don't have to be rekeyed with the new format?
Thank you in advance:cool:
View 3 Replies
View Related
Apr 22, 2014
Is it possible to mask data in a report? I have a report that contains a field for an ID number. Depending upon who is receiving the report only a partial ID number can be shown.
Example: Instead of showing ID#: 123456 the report can only show ***456.
View 3 Replies
View Related
Jan 12, 2014
I have the following expression as part of the recordsource for a report:
Is it possible to put a mask on the output of [phone1]? Ideally something like: (716) 555-5555 x1234
Code : phone1: [ContactNo1] & " " & [ContactNo1_ext]
View 10 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
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
Aug 19, 2005
Hi all
Firsty i am a novice to Databases so i only really know the basics, heres my problem.
I have a database at work that i need to password protect, but i want it so when people open it up, it gives them the option of viewing it in read only mode, but if they have the password then they can use it properly and edit things, is this possible? and if so is it easy??
Thanks everyone
Chris
View 1 Replies
View Related
Sep 1, 2005
Ok I want to do auto backup using the auto compact db, I think I got from here., anyways I want to copy it but the auto compact cant because of the DB password is there a way around this like have the password in the path of the db?
View 2 Replies
View Related
Jan 17, 2006
Hya.
In my database I've two diferents forms but I want one of them to be accessed only for few users where they have to type username and passaword.
Is anyone there could tell me how can I do that please?
Thanks
View 1 Replies
View Related
Jan 25, 2007
I don't realy know how to explain this but a college of mine has done something to her Access settings, whenever she tries to open a database it asks her for a User login password.
The prompt is a box with
Name: Centre Manager
Password:
If she types Centre Manager in the password box then it lets her in as normal. Everyone else can just access the databases without being prompted for a password.
Does anyone know what she has done?
View 2 Replies
View Related
Apr 23, 2007
A password to one of my MDB files has been changed for some reason and I need to get access to it. Does anyone know of a freeware program that I can get to gain access to it? Your help is appreciated.
View 2 Replies
View Related
May 12, 2005
I would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how?
One more question. Is it posible to based on a login name(form in FE) open a BE readonly or normaly?
Thx
View 1 Replies
View Related
May 18, 2005
I created a workgroup account with a password. I joined this work group and all has been well until my harddrive died. I have the work group and I have the password but I can't remember to user name. Is there anyway to open the work group to get the user name?
Jon
View 1 Replies
View Related
Jun 23, 2005
I'm creating a data access page that can be used over the internet to add information into the database. The database is password protected. The functionality currently is that when a user accesses the data access page, they need the database password in order to submit information. We don't have a small number of users and giving all these people the password to the database would comprimise the security of the system.
I am looking for a functionality such that the people that edit the database, either by the front end application or by opening the database directly to be password protected. But the data access page not to be.
Any ideas on how I can achieve this functionality?
View 8 Replies
View Related
Aug 3, 2005
Hi:
i have a MS Access aplication that have a vba code with a password.
Now i have a patch (in MS Access too) that will upload this full aplication, but when i try to copy a form didnt work. This is because have password in the vbe code.
someone knows how can i unlock the vbe before update the form and after update the from lock in VBA language?
thanks
View 1 Replies
View Related
Dec 14, 2005
Hi. In my database it opens up in switchboard mode. Is it possible to create a password within a switchboard?
I also different levels depending on which switchboard item they choose.
e.g. if they click "student" rather than "teacher"
How do I acheive this?
Thanks!
View 2 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
Apr 10, 2006
Hi,
I have secured my db with password. I want to know the technique/technology so that i can read my password. Access must be storing the password in an encrypted form in any password file. My idea is that if I know the file where its stored and in what form then I hope it can be retrieved.
I find so many available sites who claims that they have their product which is able to retrieve access db passowrd. I want to learn on how to do the same.
Any idea or suggestions is highly appreciated.
Thanks.
View 2 Replies
View Related
Apr 12, 2006
HI ALL,
I have been working on some database protection techniques and have found floors in all of them.
Basically I have to protect a database not using the application password... which has a different password for each form. This means using form passwords ect... but all of them can be hacked by using the shift key on start-up does anyone know how to get around this as im stuck and could really do with another’s perspective.
Thanks in advance.
View 2 Replies
View Related
May 8, 2007
Every time I open up access I get a logon box which asks for the admin password. This applies to any database project I open. I for the life of me can't figure out how it was turned on, but it still has the generic password associated with it(thank god).
I am trying to rid myself of having to type it in every single time I open up a database project. I have tried to delete it in the security section of tools and it won't allow me to delete the admin.
This is incredibly annoying because neither of the database projects requires a password, and I am not even the one that created the projects. I am merely a user.
Any suggestions on how to rid myself of this annoying problem?
View 1 Replies
View Related
Jul 27, 2007
hello,
I have a password textbox on a form. As the user types in his password I want the textbox to display the '*' symbol, just like on any log in page. How do I do this?
thanks
View 3 Replies
View Related
Aug 1, 2007
I have set a password on my access document but now need to change it - does anyone know how to do this?
View 1 Replies
View Related