By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,393 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,393 IT Pros & Developers. It's quick & easy.

Ask Password

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

Ciuky
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
"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
Nov 12 '05 #4

P: n/a
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:

Nov 12 '05 #5

P: n/a
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:


Nov 12 '05 #6

P: n/a
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()
Nov 12 '05 #7

P: n/a
"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
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.