Ask Password

[ciuky2003]

How can I ask another time the password to a customer, after that he
has done login to a protected db?

Ciuky

[Peter Russell]

ciuky2003 previously wrote:

How can I ask another time the password to a customer, after that he
has done login to a protected db?

Ciuky

You can't force the Access login to display again.

You could develop your own form to ask for it but that would be pointless
because you could not check it.

Peter Russell

[PC Datasheet]

Did you try "Please"?

:)
Steve
PC Datasheet

"ciuky2003" <ci*******@tiscalinet.it> wrote in message
news:df**************************@posting.google.c om...

How can I ask another time the password to a customer, after that he
has done login to a protected db?

Ciuky

[Fletcher Arnold]

"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me***********************@russellscott.btinte rnet.com...

ciuky2003 previously wrote:

How can I ask another time the password to a customer, after that he
has done login to a protected db?

Ciuky

You can't force the Access login to display again.

You could develop your own form to ask for it but that would be pointless
because you could not check it.

Peter Russell

you could not check it?

(...cracks aside) although you couldn't find out the password if you didn't
know it, you could check it to see if a given password was right or wrong -
although I can't see the point:

Public Sub CheckPassword()

On Error Resume Next

Dim wks As DAO.Workspace
Dim strUserName As String
Dim strPassword As String

strUserName = CurrentUser

strPassword = InputBox("What is your password?")

Set wks = DBEngine.CreateWorkspace("wksJET", strUserName, strPassword)

If Err.Number = 0 Then
MsgBox "Correct!", vbInformation
Else
MsgBox "Wrong!", vbCritical
End If

If Not wks Is Nothing Then
Set wks = Nothing
End If

End Sub

Fletcher

[Peter Russell]

Very good.

It has never occurred to me to do this.

This would satisfy the original poster then.

I assume it's something to do with making sure that some functions really
are carried out by the person who originally logged in - and not by
someone who happened to be passing by the user's desk

Regards

Peter Russell

Fletcher Arnold previously wrote:

you could not check it?

(...cracks aside) although you couldn't find out the password if you
didn't
know it, you could check it to see if a given password was right or
wrong -
although I can't see the point:

[Michael \(michka\) Kaplan [MS]]

Of course, given how trivial it would be to write an app that popped up a
window in front of access that looked like a logon dialog, they could easily
convince someone to ype in credentials....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me***********************@russellscott.btinte rnet.com...

Very good.

It has never occurred to me to do this.

This would satisfy the original poster then.

I assume it's something to do with making sure that some functions really
are carried out by the person who originally logged in - and not by
someone who happened to be passing by the user's desk

Regards

Peter Russell

Fletcher Arnold previously wrote:

you could not check it?

(...cracks aside) although you couldn't find out the password if you
didn't
know it, you could check it to see if a given password was right or
wrong -
although I can't see the point:

[Trevor Best]

Michael (michka) Kaplan [MS] wrote:

Of course, given how trivial it would be to write an app that popped up a
window in front of access that looked like a logon dialog, they could easily
convince someone to ype in credentials....

I had an app on a Palm Pilot that you put your thumb on, being a touch
screen as soon as you did it said Access Denied, my boss thought it was
real.

You can also make that login box modal and test the password against the
current security context using dao.createworkspace()

[ciuky2003]

"Fletcher Arnold" <fl****@home.com> wrote in message news:<c1**********@titan.btinternet.com>...

"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me***********************@russellscott.btinte rnet.com...

ciuky2003 previously wrote:

How can I ask another time the password to a customer, after that he
has done login to a protected db?

Ciuky

You can't force the Access login to display again.

You could develop your own form to ask for it but that would be pointless
because you could not check it.

Peter Russell

you could not check it?

(...cracks aside) although you couldn't find out the password if you didn't
know it, you could check it to see if a given password was right or wrong -
although I can't see the point:

Public Sub CheckPassword()

On Error Resume Next

Dim wks As DAO.Workspace
Dim strUserName As String
Dim strPassword As String

strUserName = CurrentUser

strPassword = InputBox("What is your password?")

Set wks = DBEngine.CreateWorkspace("wksJET", strUserName, strPassword)

If Err.Number = 0 Then
MsgBox "Correct!", vbInformation
Else
MsgBox "Wrong!", vbCritical
End If

If Not wks Is Nothing Then
Set wks = Nothing
End If

End Sub

Fletcher

Tank you,

it's a very good solution to my question!!

Ciuky