|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Prompting for passwordI have developed a form which connect to other database and list all the
users connected to it. In most cases, I have to enter a password in order to do it. My question is: Is there an InputBox Masked? I mean, if I use InputBox to ask for a password, it will show the typed password because it is not masked as ****. Is there a way to open the login dialog to log into the new database? Thanks Mauricio Silva 2005 Hi, Mauricio.
> Is there an InputBox Masked? Yes. Open the form in Design View. Select the text box that accepts the password typed by the user. Open the Properties dialog window. Select the "Data" tab. In the "Input Mask" Property, type: Password Save the form, then open it in Form View. The user's input will now have an * displayed for each character typed into the password text box, thereby hiding the actual password from passersby. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) - - - When you see correct answers to your question posted in Microsoft's Online Community, please sign in to the Community and mark these posts as "Answers," so that all may benefit by filtering on "Answered questions" and quickly finding the right answers to similar questions. Remember that the first and best answers are often given to those who have a history of rewarding the contributors who have taken the time to answer questions correctly. Show quoteHide quote "Mauricio Silva" wrote: > I have developed a form which connect to other database and list all the > users connected to it. In most cases, I have to enter a password in order to > do it. My question is: > > Is there an InputBox Masked? I mean, if I use InputBox to ask for a > password, it will show the typed password because it is not masked as ****. > Is there a way to open the login dialog to log into the new database? > > Thanks > Mauricio Silva 2005 > Hi Gunny,
thank you for your answer, but I think I didn't explain myself quite well. I am trying to avoid creating a new form just to input a password, what I am asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile or an Access Dialog such as InputBox. Maybe an InputPassword Dialog. Thanks again Mauricio Silva 2005 Show quoteHide quote "'69 Camaro" wrote: > Hi, Mauricio. > > > Is there an InputBox Masked? > > Yes. Open the form in Design View. Select the text box that accepts the > password typed by the user. Open the Properties dialog window. Select the > "Data" tab. In the "Input Mask" Property, type: > > Password > > Save the form, then open it in Form View. The user's input will now have an > * displayed for each character typed into the password text box, thereby > hiding the actual password from passersby. > > HTH. > > Gunny > > See http://www.QBuilt.com for all your database needs. > See http://www.Access.QBuilt.com for Microsoft Access tips. > > (Please remove ZERO_SPAM from my reply E-mail address, so that a message > will be forwarded to me.) > > - - - > When you see correct answers to your question posted in Microsoft's Online > Community, please sign in to the Community and mark these posts as "Answers," > so that all may benefit by filtering on "Answered questions" and quickly > finding the right answers to similar questions. Remember that the first and > best answers are often given to those who have a history of rewarding the > contributors who have taken the time to answer questions correctly. > > > "Mauricio Silva" wrote: > > > I have developed a form which connect to other database and list all the > > users connected to it. In most cases, I have to enter a password in order to > > do it. My question is: > > > > Is there an InputBox Masked? I mean, if I use InputBox to ask for a > > password, it will show the typed password because it is not masked as ****. > > Is there a way to open the login dialog to log into the new database? > > > > Thanks > > Mauricio Silva 2005 > > Hi, Mauricio.
> I am trying to avoid creating a new form just to input a password Oh. I assumed that the form you had already created to connect to the other database and list the users connected to it had a text box available for the user to type the password, since you mentioned that you had to enter a password in most cases to connect to the other database. > what I am The only pre-programmed dialog window for this is the InputBox, which does > asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile > or an Access Dialog such as InputBox. Maybe an InputPassword Dialog. not allow for input masks. Other than that, you'll have to create a separate form, add a text box to a current form, or call an external executable file that displays the user-defined dialog window that includes an input mask for a password, then pass it to the database to connect to. You could create a form in an executable file with Visual Basic, but that's a lot more trouble than just adding a special text box or creating a special form within Access. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) - - - When you see correct answers to your question posted in Microsoft's Online Community, please sign in to the Community and mark these posts as "Answers," so that all may benefit by filtering on "Answered questions" and quickly finding the right answers to similar questions. Remember that the first and best answers are often given to those who have a history of rewarding the contributors who have taken the time to answer questions correctly. Show quoteHide quote "Mauricio Silva" wrote: > Hi Gunny, > > thank you for your answer, but I think I didn't explain myself quite well. > > I am trying to avoid creating a new form just to input a password, what I am > asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile > or an Access Dialog such as InputBox. Maybe an InputPassword Dialog. > > Thanks again > > Mauricio Silva 2005 > > "'69 Camaro" wrote: > > > Hi, Mauricio. > > > > > Is there an InputBox Masked? > > > > Yes. Open the form in Design View. Select the text box that accepts the > > password typed by the user. Open the Properties dialog window. Select the > > "Data" tab. In the "Input Mask" Property, type: > > > > Password > > > > Save the form, then open it in Form View. The user's input will now have an > > * displayed for each character typed into the password text box, thereby > > hiding the actual password from passersby. > > > > HTH. > > > > Gunny > > > > See http://www.QBuilt.com for all your database needs. > > See http://www.Access.QBuilt.com for Microsoft Access tips. > > > > (Please remove ZERO_SPAM from my reply E-mail address, so that a message > > will be forwarded to me.) > > > > - - - > > When you see correct answers to your question posted in Microsoft's Online > > Community, please sign in to the Community and mark these posts as "Answers," > > so that all may benefit by filtering on "Answered questions" and quickly > > finding the right answers to similar questions. Remember that the first and > > best answers are often given to those who have a history of rewarding the > > contributors who have taken the time to answer questions correctly. > > > > > > "Mauricio Silva" wrote: > > > > > I have developed a form which connect to other database and list all the > > > users connected to it. In most cases, I have to enter a password in order to > > > do it. My question is: > > > > > > Is there an InputBox Masked? I mean, if I use InputBox to ask for a > > > password, it will show the typed password because it is not masked as ****. > > > Is there a way to open the login dialog to log into the new database? > > > > > > Thanks > > > Mauricio Silva 2005 > > > Actually this is possible, but requires the use of hooks (therefore I would
generally advise the normal form based approach). If you want to use the Win API hook approach - you can read it here: http://www.danielklann.com/excel/hiding_text_in_a_vba_inputbox.htm Regards, Wayne Phillips http://www.everythingaccess.com Show quoteHide quote "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote in message news:4BDD9F68-E032-491F-A9A6-3EF08D2322E3@microsoft.com... > Hi, Mauricio. > > > I am trying to avoid creating a new form just to input a password > > Oh. I assumed that the form you had already created to connect to the other > database and list the users connected to it had a text box available for the > user to type the password, since you mentioned that you had to enter a > password in most cases to connect to the other database. > > > what I am > > asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile > > or an Access Dialog such as InputBox. Maybe an InputPassword Dialog. > > The only pre-programmed dialog window for this is the InputBox, which does > not allow for input masks. Other than that, you'll have to create a separate > form, add a text box to a current form, or call an external executable file > that displays the user-defined dialog window that includes an input mask for > a password, then pass it to the database to connect to. You could create a > form in an executable file with Visual Basic, but that's a lot more trouble > than just adding a special text box or creating a special form within Access. > > HTH. > > Gunny > > See http://www.QBuilt.com for all your database needs. > See http://www.Access.QBuilt.com for Microsoft Access tips. > > (Please remove ZERO_SPAM from my reply E-mail address, so that a message > will be forwarded to me.) > > - - - > When you see correct answers to your question posted in Microsoft's Online > Community, please sign in to the Community and mark these posts as "Answers," > so that all may benefit by filtering on "Answered questions" and quickly > finding the right answers to similar questions. Remember that the first and > best answers are often given to those who have a history of rewarding the > contributors who have taken the time to answer questions correctly. > > > "Mauricio Silva" wrote: > > > Hi Gunny, > > > > thank you for your answer, but I think I didn't explain myself quite well. > > > > I am trying to avoid creating a new form just to input a password, what I am > > asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile > > or an Access Dialog such as InputBox. Maybe an InputPassword Dialog. > > > > Thanks again > > > > Mauricio Silva 2005 > > > > "'69 Camaro" wrote: > > > > > Hi, Mauricio. > > > > > > > Is there an InputBox Masked? > > > > > > Yes. Open the form in Design View. Select the text box that accepts the > > > password typed by the user. Open the Properties dialog window. Select the > > > "Data" tab. In the "Input Mask" Property, type: > > > > > > Password > > > > > > Save the form, then open it in Form View. The user's input will now have an > > > * displayed for each character typed into the password text box, thereby > > > hiding the actual password from passersby. > > > > > > HTH. > > > > > > Gunny > > > > > > See http://www.QBuilt.com for all your database needs. > > > See http://www.Access.QBuilt.com for Microsoft Access tips. > > > > > > (Please remove ZERO_SPAM from my reply E-mail address, so that a message > > > will be forwarded to me.) > > > > > > - - - > > > When you see correct answers to your question posted in Microsoft's Online > > > Community, please sign in to the Community and mark these posts as "Answers," > > > so that all may benefit by filtering on "Answered questions" and quickly > > > finding the right answers to similar questions. Remember that the first and > > > best answers are often given to those who have a history of rewarding the > > > contributors who have taken the time to answer questions correctly. > > > > > > > > > "Mauricio Silva" wrote: > > > > > > > I have developed a form which connect to other database and list all the > > > > users connected to it. In most cases, I have to enter a password in order to > > > > do it. My question is: > > > > > > > > Is there an InputBox Masked? I mean, if I use InputBox to ask for a > > > > password, it will show the typed password because it is not masked as ****. > > > > Is there a way to open the login dialog to log into the new database? > > > > > > > > Thanks > > > > Mauricio Silva 2005 > > > >
Restrict use of Access to one computer
Splitting a secure database MS ACESS cannot open this file error (new uer) General Question How do I get back into a database as the administrator once I hav. How do I remove user level security? RE: Urgent: Securing My Access from Piracy How do I change Access ownership from <unknown>? Application Property Cant get in to my database |
|||||||||||||||||||||||