Home All Groups Group Topic Archive Search About

Password for CurrentUser()

Author
10 Oct 2006 10:12 PM
Vensia
Dear all,

I'm using MDW file in my application.
After the user login, can I know the password of CurrentUser() ?
Thanks.

Regards
Vensia

Author
10 Oct 2006 1:18 PM
Joan Wild
You can't.  Why do you need to know?  If you describe what you want to do,
there is likely a way.

--
Joan Wild
Microsoft Access MVP

Vensia wrote:
Show quote
> Dear all,
>
> I'm using MDW file in my application.
> After the user login, can I know the password of CurrentUser() ?
> Thanks.
>
> Regards
> Vensia
Author
10 Oct 2006 5:28 PM
Vensia
Hi Joan,

Actually I have several users. If I use MDW file, a user can save a version
of existing MDW file, and then using it to open the application. I want
there is a double checking for login validation.
Thanks.

Vensia

Show quote
"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
> You can't.  Why do you need to know?  If you describe what you want to do,
> there is likely a way.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Vensia wrote:
> > Dear all,
> >
> > I'm using MDW file in my application.
> > After the user login, can I know the password of CurrentUser() ?
> > Thanks.
> >
> > Regards
> > Vensia
>
>
Author
10 Oct 2006 5:57 PM
Joan Wild
Why would it be a problem if they saved and used a different copy of the
MDW?


--
Joan Wild
Microsoft Access MVP

Vensia wrote:
Show quote
> Hi Joan,
>
> Actually I have several users. If I use MDW file, a user can save a
> version of existing MDW file, and then using it to open the
> application. I want there is a double checking for login validation.
> Thanks.
>
> Vensia
>
> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
>> You can't.  Why do you need to know?  If you describe what you want
>> to do, there is likely a way.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Vensia wrote:
>>> Dear all,
>>>
>>> I'm using MDW file in my application.
>>> After the user login, can I know the password of CurrentUser() ?
>>> Thanks.
>>>
>>> Regards
>>> Vensia
Author
11 Oct 2006 2:35 AM
Vensia
Let say I have a mdw file called payroll.mdw
In payroll.mdw file, default user name is admin with password 12345
Then the IT staff saves this payroll.mdw file in his PC.
Later, the HR manager change the password for Admin user.
Then the IT staff still can open the application using his MDW file with
default user name and password.
That's the problem.
Thanks.

Vensia



Show quote
"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:#slF9VJ7GHA.2384@TK2MSFTNGP04.phx.gbl...
> Why would it be a problem if they saved and used a different copy of the
> MDW?
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Vensia wrote:
> > Hi Joan,
> >
> > Actually I have several users. If I use MDW file, a user can save a
> > version of existing MDW file, and then using it to open the
> > application. I want there is a double checking for login validation.
> > Thanks.
> >
> > Vensia
> >
> > "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> > news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
> >> You can't.  Why do you need to know?  If you describe what you want
> >> to do, there is likely a way.
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Vensia wrote:
> >>> Dear all,
> >>>
> >>> I'm using MDW file in my application.
> >>> After the user login, can I know the password of CurrentUser() ?
> >>> Thanks.
> >>>
> >>> Regards
> >>> Vensia
>
>
Author
11 Oct 2006 5:00 PM
Joan Wild
The Admin user shouldn't have any permission to do anything anyway, so it
shouldn't matter.

I would give the HR manager and the IT staff different usernames; they can
each change their own password all they want.

I can see a scenario where it may be a problem:

1. you manage permissions by group.
2. a person is a member of Full Permissions group
3. that person takes a copy of the mdw
4. that person is later demoted and taken out of the Full Permissions group
and put into Read Only
5. since they have an earlier copy of the mdw, and are using that, they can
still get in as Full Permissions member.

The workaround to that is to manage permissions by user, not group.  That
takes more work, but would prevent someone from getting around the security
using the mdw (since permissions are stored in the mdb).

You cannot retrieve the password of the CurrentUser (you can check that it
isn't null, and you can reset it to null)


--
Joan Wild
Microsoft Access MVP

Vensia wrote:
Show quote
> Let say I have a mdw file called payroll.mdw
> In payroll.mdw file, default user name is admin with password 12345
> Then the IT staff saves this payroll.mdw file in his PC.
> Later, the HR manager change the password for Admin user.
> Then the IT staff still can open the application using his MDW file
> with default user name and password.
> That's the problem.
> Thanks.
>
> Vensia
>
>
>
> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> news:#slF9VJ7GHA.2384@TK2MSFTNGP04.phx.gbl...
>> Why would it be a problem if they saved and used a different copy of
>> the MDW?
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Vensia wrote:
>>> Hi Joan,
>>>
>>> Actually I have several users. If I use MDW file, a user can save a
>>> version of existing MDW file, and then using it to open the
>>> application. I want there is a double checking for login validation.
>>> Thanks.
>>>
>>> Vensia
>>>
>>> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
>>> news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
>>>> You can't.  Why do you need to know?  If you describe what you want
>>>> to do, there is likely a way.
>>>>
>>>> --
>>>> Joan Wild
>>>> Microsoft Access MVP
>>>>
>>>> Vensia wrote:
>>>>> Dear all,
>>>>>
>>>>> I'm using MDW file in my application.
>>>>> After the user login, can I know the password of CurrentUser() ?
>>>>> Thanks.
>>>>>
>>>>> Regards
>>>>> Vensia
Author
12 Oct 2006 2:25 AM
Vensia
According to you, what is the best security approach for payroll software
product ?
Each time the software is intalled, there is a default user name and
password.
If there are 2 installations (2 company) in the same office, I want to the
user can not use his mdw to open the other company's data.
Thanks.

Vensia

Show quote
"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:OE6#$aV7GHA.568@TK2MSFTNGP05.phx.gbl...
> The Admin user shouldn't have any permission to do anything anyway, so it
> shouldn't matter.
>
> I would give the HR manager and the IT staff different usernames; they can
> each change their own password all they want.
>
> I can see a scenario where it may be a problem:
>
> 1. you manage permissions by group.
> 2. a person is a member of Full Permissions group
> 3. that person takes a copy of the mdw
> 4. that person is later demoted and taken out of the Full Permissions
group
> and put into Read Only
> 5. since they have an earlier copy of the mdw, and are using that, they
can
> still get in as Full Permissions member.
>
> The workaround to that is to manage permissions by user, not group.  That
> takes more work, but would prevent someone from getting around the
security
> using the mdw (since permissions are stored in the mdb).
>
> You cannot retrieve the password of the CurrentUser (you can check that it
> isn't null, and you can reset it to null)
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Vensia wrote:
> > Let say I have a mdw file called payroll.mdw
> > In payroll.mdw file, default user name is admin with password 12345
> > Then the IT staff saves this payroll.mdw file in his PC.
> > Later, the HR manager change the password for Admin user.
> > Then the IT staff still can open the application using his MDW file
> > with default user name and password.
> > That's the problem.
> > Thanks.
> >
> > Vensia
> >
> >
> >
> > "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> > news:#slF9VJ7GHA.2384@TK2MSFTNGP04.phx.gbl...
> >> Why would it be a problem if they saved and used a different copy of
> >> the MDW?
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Vensia wrote:
> >>> Hi Joan,
> >>>
> >>> Actually I have several users. If I use MDW file, a user can save a
> >>> version of existing MDW file, and then using it to open the
> >>> application. I want there is a double checking for login validation.
> >>> Thanks.
> >>>
> >>> Vensia
> >>>
> >>> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> >>> news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
> >>>> You can't.  Why do you need to know?  If you describe what you want
> >>>> to do, there is likely a way.
> >>>>
> >>>> --
> >>>> Joan Wild
> >>>> Microsoft Access MVP
> >>>>
> >>>> Vensia wrote:
> >>>>> Dear all,
> >>>>>
> >>>>> I'm using MDW file in my application.
> >>>>> After the user login, can I know the password of CurrentUser() ?
> >>>>> Thanks.
> >>>>>
> >>>>> Regards
> >>>>> Vensia
>
>
Author
12 Oct 2006 12:09 PM
Joan Wild
Vensia wrote:
> According to you, what is the best security approach for payroll
> software product ?
> Each time the software is intalled, there is a default user name and
> password.

Not sure what you mean by this?  When access first presents the login
dialog, it will fill in the username with the Windows logon name, and the
password will be blank.  The username can be changed to whatever it needs to
be.  The next time the login dialog is shown, it'll show the username of the
last person who used it.

> If there are 2 installations (2 company) in the same office, I want
> to the user can not use his mdw to open the other company's data.
> Thanks.


I would create separate groups for the 2 companies.  Make sure that said
user isn't a member of company two's group.

--
Joan Wild
Microsoft Access MVP
Author
13 Oct 2006 9:47 AM
Vensia
I mean this is a mass product. So there is already a user with name : admin
and password : 123.
Anyone who buy the product will have the same user name and password for the
first time login.
What is your suggestion for the good security ?
Thanks.


Show quote
"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:uAzo2cf7GHA.5020@TK2MSFTNGP03.phx.gbl...
>
> Vensia wrote:
> > According to you, what is the best security approach for payroll
> > software product ?
> > Each time the software is intalled, there is a default user name and
> > password.
>
> Not sure what you mean by this?  When access first presents the login
> dialog, it will fill in the username with the Windows logon name, and the
> password will be blank.  The username can be changed to whatever it needs
to
> be.  The next time the login dialog is shown, it'll show the username of
the
> last person who used it.
>
> > If there are 2 installations (2 company) in the same office, I want
> > to the user can not use his mdw to open the other company's data.
> > Thanks.
>
>
> I would create separate groups for the 2 companies.  Make sure that said
> user isn't a member of company two's group.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
Author
13 Oct 2006 11:44 AM
Rick Brandt
Vensia wrote:
> I mean this is a mass product. So there is already a user with name :
> admin and password : 123.
> Anyone who buy the product will have the same user name and password
> for the first time login.
> What is your suggestion for the good security ?
> Thanks.

The user "Admin" is the same in all workgroup files, but it only has that
password in YOUR workgroup. If you are allowing that user to open the file then
you are letting anyone open the file as long as they use a workgroup that has no
password on the Admin user or one where they know the password for the Admin
user.

The most basic rule of Access security is that the default user Admin and the
default group Users must have zero permissions and zero ownership.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com
Author
26 Oct 2006 5:12 AM
Chris Mills
> I mean this is a mass product.

There's a significant problem with changing passwords on "mass products". If
you use PDW to distribute, there is NO provision for network setups. This
means, by default, I have a copy of the mdw in each local folder. To fix it,
requires "shifting" mdw to the network folder, perhaps by a long telephone
conversation. Very long!

I don't worry too much about it, because "most" sites don't worry about
changing passwords, but if they do they have to shift it (the mdw)(let alone
old backups).

There is no workaround (no reasonable network mdw install) in PDW. Other
installers like Sagekey or Installer2Go may or may not have.

Whatever I did, on a "mass product" they could always restore the original CD
mdw, which in my case has no passwords! (except for the assignated "DBA", but
even then it is standard across all sites)

Why am I fighting a losing battle with Access Security? <grin>

Chris
Author
26 Oct 2006 4:58 AM
Chris Mills
Just to get my understanding right (not yours), any given perms on a table are
contained within the live MDB, right? There is only one usefull copy of them.

She (or Vensia) was talking about passwords,which are contained in the mdw,
something which doesn't change that often, and might well have old useable
copies lying about?

Managing by User not Group is an interesting idea (against the normal advice),
but if I read things right this might not achieve much? The User might still
be in an old mdw, making that pointless? She (or, it!) referred only to
changing passwords?

I also think they (or, she!) are getting beyond the capacity of Access
Security. Certainly, you could restore a backup of mine (where I changed
passwords) and use the older ones!

Chris

Show quote
"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:OE6%23$aV7GHA.568@TK2MSFTNGP05.phx.gbl...
> The Admin user shouldn't have any permission to do anything anyway, so it
> shouldn't matter.
>
> I would give the HR manager and the IT staff different usernames; they can
> each change their own password all they want.
>
> I can see a scenario where it may be a problem:
>
> 1. you manage permissions by group.
> 2. a person is a member of Full Permissions group
> 3. that person takes a copy of the mdw
> 4. that person is later demoted and taken out of the Full Permissions group
> and put into Read Only
> 5. since they have an earlier copy of the mdw, and are using that, they can
> still get in as Full Permissions member.
>
> The workaround to that is to manage permissions by user, not group.  That
> takes more work, but would prevent someone from getting around the security
> using the mdw (since permissions are stored in the mdb).
>
> You cannot retrieve the password of the CurrentUser (you can check that it
> isn't null, and you can reset it to null)
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Vensia wrote:
> > Let say I have a mdw file called payroll.mdw
> > In payroll.mdw file, default user name is admin with password 12345
> > Then the IT staff saves this payroll.mdw file in his PC.
> > Later, the HR manager change the password for Admin user.
> > Then the IT staff still can open the application using his MDW file
> > with default user name and password.
> > That's the problem.
> > Thanks.
> >
> > Vensia
> >
> >
> >
> > "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> > news:#slF9VJ7GHA.2384@TK2MSFTNGP04.phx.gbl...
> >> Why would it be a problem if they saved and used a different copy of
> >> the MDW?
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Vensia wrote:
> >>> Hi Joan,
> >>>
> >>> Actually I have several users. If I use MDW file, a user can save a
> >>> version of existing MDW file, and then using it to open the
> >>> application. I want there is a double checking for login validation.
> >>> Thanks.
> >>>
> >>> Vensia
> >>>
> >>> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> >>> news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
> >>>> You can't.  Why do you need to know?  If you describe what you want
> >>>> to do, there is likely a way.
> >>>>
> >>>> --
> >>>> Joan Wild
> >>>> Microsoft Access MVP
> >>>>
> >>>> Vensia wrote:
> >>>>> Dear all,
> >>>>>
> >>>>> I'm using MDW file in my application.
> >>>>> After the user login, can I know the password of CurrentUser() ?
> >>>>> Thanks.
> >>>>>
> >>>>> Regards
> >>>>> Vensia
>
>
Author
26 Oct 2006 1:10 PM
Joan Wild
Chris Mills wrote:
> Just to get my understanding right (not yours), any given perms on a
> table are contained within the live MDB, right? There is only one
> usefull copy of them.

Exactly.

> Managing by User not Group is an interesting idea (against the normal
> advice), but if I read things right this might not achieve much? The
> User might still be in an old mdw, making that pointless?

But why is that pointless?  Once logged in as that user (regardless of what
mdw they use), they are still restricted by the permissions that are applied
to that username, which is stored in the mdb.


--
Joan Wild
Author
26 Oct 2006 11:33 PM
Chris Mills
> > User might still be in an old mdw, making that pointless?
>
> But why is that pointless?

I read Vensia, in the payroll example, as a customer altering their password,
and of course the old password can be re-implemented with a restored mdw.

If that is her issue, I agree it is true! I don't know of a way to protect
from restoring old backups -unless one did some sort of re-securing, which is
not usually (there I go again!) contemplated after deployment.

I could always have mis-read Vensia :-)

I didn't really worry about things like potential old password restoral (you
can't worry TOO much about securing Access can you!) Whilst I want my PROGRAM
reasonably protected from copying, if a client has IT smart-alecs I'd be
inclined to give-up. More accurately, other security like restricted physical
access to the Accountant's machine. I think it's fair to say that site
security cannot solely be what Access provides?

(employees have to sign non-disclosure agreements, are liable to prosecution,
locked open-plan offices <guffaw>, but certainly not solely Access)

Just to clarify, my s/w (a CD distributed to xxx sites), of course has the
same passwords for each. The Developer password is known only to me <g>, the
site DBA password is pre-set to some published value which the site DBA can
change, and all the users are initially set to blank passwords (or a published
password who cares) which they can change if they want. And if they change
passwords, they can always restore the original ones from the distribution CD!

This is specific to bulk-distributing the same CD. It might be very different
if you can personally customise each site. The program-copying security is
other things (like, dare I say it, dongles or HD serial numbers)

I do not realistically protect the client from their own data (using Access).
Call me a b'tard, but I'm only interested in my prog being ripped off! I CANT
protect them from their data (?)

BTW, in a "closed vertical market" other security can come into effect, such
as eventually some rip-off site will forget and call the published phone
number for service! It's true, it has happened to me! It helps if your prog is
badly written so that it needs service <g>

Chris
Author
27 Oct 2006 2:08 PM
Joan Wild
Chris Mills wrote:
>>> User might still be in an old mdw, making that pointless?
>>
>> But why is that pointless?
>
> I read Vensia, in the payroll example, as a customer altering their
> password, and of course the old password can be re-implemented with a
> restored mdw.
>
> If that is her issue, I agree it is true! I don't know of a way to
> protect from restoring old backups -unless one did some sort of
> re-securing, which is not usually (there I go again!) contemplated
> after deployment.

But my point was that instead of applying permissions to groups, you can
apply them to users.  Even if a user restores an old mdw and uses their old
password, they won't get the permissions they had with that old password,
they'll get the permissions applied to that username, which are stored in
the mdb.

--
Joan Wild
Author
27 Oct 2006 6:28 PM
Chris Mills
I don't follow you at all/

A user can change their password. Perms don't alter just for this change.

Old password can be restored with old mdw. (just another way of changing the
password back)

Doesn't matter if perms are on users or groups, or so my tests indicate. They
are not affected by change of password (as against PID say)

(a client would do no more than change their password, on a bulk product
anyway. That's a minor mdw change only, however perms are set up).

But perhaps let Vensia come back with something. I always fear I misunderstood
something :-)

Chris
Author
27 Oct 2006 7:16 PM
Joan Wild
We are talking about different things.  I put forward the scenario where you
manage security by groups.  A user takes a copy of the mdw in which they are
a member of the supergroup.  In the original group, they are removed from
supergroup and put in the peon group.  If they use their copy of the mdw,
they can over-ride the change to the peon group.  In their mdw they are
still a member of supergroup, so by using that mdw they will have
permissions they shouldn't.

A workaround is to manage permissions by user instead of by group.  It has
nothing to do with password changes.


--
Joan Wild
Microsoft Access MVP

Chris Mills wrote:
Show quote
> I don't follow you at all/
>
> A user can change their password. Perms don't alter just for this
> change.
>
> Old password can be restored with old mdw. (just another way of
> changing the password back)
>
> Doesn't matter if perms are on users or groups, or so my tests
> indicate. They are not affected by change of password (as against PID
> say)
>
> (a client would do no more than change their password, on a bulk
> product anyway. That's a minor mdw change only, however perms are set
> up).
>
> But perhaps let Vensia come back with something. I always fear I
> misunderstood something :-)
>
> Chris
Author
28 Oct 2006 2:18 AM
Chris Mills
Are "peon"s inhabitants of Venus?
(sorry - no meaning!)

Well, I see that, if structural changes have taken place (regarding changing
groups around as structural).

But hopefully <g> on a "mass product", such things were stabilised during
development.

With the best ULS setup in the world (which I always do of course <cough>), of
course (mass product) Company1 and Company2 have the same initial passwords.
Which can be reverted to at any time or by any means.

Vensia,
Without tailoring the mdw or ULS each time, of course Company2 could
potentially access Company1 data. If it's the identical bulk "setup", there's
no difference whatever between a Company2 machine or another machine installed
at Company1.

Rick referred to not using "admin", if you meant that username literally,
because it's a default "superuser" for all Access. I am assuming your ULS
security is setup "perfectly"/your issue seems still true.

Because "bulk product" means IDENTICAL (at installation), yes one of my
clients using the same product can get into another client's data, if they had
physical access and a copy of the original mdw. I simply regard that as
obvious/nothing I can do much about (apart from tailoring each site).
Alternative viewpoint is: you (as developer) or me (with 1/10 of Joan's
knowledge) could no doubt get into it too - so anyone with an average or so
knowledge of Access security can!

For the same reason, I distribute standard logons like User1 to Userxxx
(mappable to actual names within the program), because the user can't modify
security beyond changing passwords. Is there a better (and secure)way to let
users setup logons?

(I have a specific interest in new suggestions here! :-) )
Chris
Author
26 Oct 2006 4:57 AM
Chris Mills
Jumping in halfway in reviewing this thread, yes it's true that saving a copy
of an mdw saves "old" passwords.

I usually look at it the other way, that multiple copies of an mdw mean if you
change one password, you may not have changed all copies of it! (due to
limitations of PDW installs, I often have multiple copies of an mdw, accepting
that it's naughty if I want to change passwords etc).

Anyhow, yes that's a danger (old files/old passwords). Whatever you do, you
couldn't prevent (for instance) someone recovering an old backup mdw! (unless
someone else knows how)

I think Access Security is quite good, so far as it goes. But consider the
possibility that you are trying to ascribe to Access more security than is
there! (some claim, with reason, that it is not secure at all, which I think
is slightly exaggerated/only true of Access Experts)

You are talking about a File Management problem, which at least requires an
On-Site Administrator with integrity. As such, it is nothing to do with
"Access Security" per se, and you already understand the issue by posting it.

There's a thousand ways in which Access security can be broken (I am told!),
of which you have identified just one. I have heard that it's recoverable even
without the mdw. It is often said, that if you want beyond a certain level of
security, then you might like to consider SQLserver or some-such.

As has been mentioned, you wouldn't have a logon of Admin (or any one of the
Access default users or groups), but something else like YourDBA. I think the
SecFAQ covers this adequately. But it doesn't cover old copies because no-one
can?

I think Access Security works fine for the average Office Secretary and CEO
(!!!)

Also by my reading, it all becomes irrelevant from A2007 (except for
legacy-mode). Not Security becomes irrelevant, but ULS does. If you are
contemplating using the latest Access, it seems to me you would need to
discard all current concepts. (I'm not myself interested in latest Access)

Chris

Show quote
"Vensia" <vensia2000_nospam@yahoo.com> wrote in message
news:eNyoJ3N7GHA.4580@TK2MSFTNGP03.phx.gbl...
> Let say I have a mdw file called payroll.mdw
> In payroll.mdw file, default user name is admin with password 12345
> Then the IT staff saves this payroll.mdw file in his PC.
> Later, the HR manager change the password for Admin user.
> Then the IT staff still can open the application using his MDW file with
> default user name and password.
> That's the problem.
> Thanks.
>
> Vensia
>
>
>
> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> news:#slF9VJ7GHA.2384@TK2MSFTNGP04.phx.gbl...
> > Why would it be a problem if they saved and used a different copy of the
> > MDW?
> >
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> >
> > Vensia wrote:
> > > Hi Joan,
> > >
> > > Actually I have several users. If I use MDW file, a user can save a
> > > version of existing MDW file, and then using it to open the
> > > application. I want there is a double checking for login validation.
> > > Thanks.
> > >
> > > Vensia
> > >
> > > "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> > > news:Oi8g27G7GHA.4996@TK2MSFTNGP03.phx.gbl...
> > >> You can't.  Why do you need to know?  If you describe what you want
> > >> to do, there is likely a way.
> > >>
> > >> --
> > >> Joan Wild
> > >> Microsoft Access MVP
> > >>
> > >> Vensia wrote:
> > >>> Dear all,
> > >>>
> > >>> I'm using MDW file in my application.
> > >>> After the user login, can I know the password of CurrentUser() ?
> > >>> Thanks.
> > >>>
> > >>> Regards
> > >>> Vensia
> >
> >
>
>
Author
4 Nov 2006 9:49 PM
Nip
Hi

Probably this helps:
System.Web.Security.ActiveDirectoryMembershipProvider.GetPassword(ByVal
username As String, ByVal passwordAnswer As String) As String

Bye

Show quote
"Vensia" <vensia2000_nospam@yahoo.com> wrote in message
news:e$6%23f6D7GHA.1560@TK2MSFTNGP04.phx.gbl...
> Dear all,
>
> I'm using MDW file in my application.
> After the user login, can I know the password of CurrentUser() ?
> Thanks.
>
> Regards
> Vensia
>
>
Author
4 Nov 2006 9:54 PM
Nip
This could help, too
:

http://www.vbdotnetheaven.com/UploadFile/ankithakur/Login_Using_Active_Directory08012006061813AM/Login_Using_Active_Directory.aspx


Bye
Nip

Show quote
"Nip" <lu***@quantentunnel.de> wrote in message
news:ORMmqsFAHHA.4328@TK2MSFTNGP03.phx.gbl...
> Hi
>
> Probably this helps:
> System.Web.Security.ActiveDirectoryMembershipProvider.GetPassword(ByVal
> username As String, ByVal passwordAnswer As String) As String
>
> Bye
>
> "Vensia" <vensia2000_nospam@yahoo.com> wrote in message
> news:e$6%23f6D7GHA.1560@TK2MSFTNGP04.phx.gbl...
>> Dear all,
>>
>> I'm using MDW file in my application.
>> After the user login, can I know the password of CurrentUser() ?
>> Thanks.
>>
>> Regards
>> Vensia
>>
>>
>
Author
5 Nov 2006 12:00 PM
Douglas J. Steele
1) There's no connection between CurrentUser in Access and whatever has been
defined in ActiveDirectory.

2) Your code samples are .Net, whereas Access uses VBA.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


Show quote
"Nip" <lu***@quantentunnel.de> wrote in message
news:ORMmqsFAHHA.4328@TK2MSFTNGP03.phx.gbl...
> Hi
>
> Probably this helps:
> System.Web.Security.ActiveDirectoryMembershipProvider.GetPassword(ByVal
> username As String, ByVal passwordAnswer As String) As String
>
> Bye
>
> "Vensia" <vensia2000_nospam@yahoo.com> wrote in message
> news:e$6%23f6D7GHA.1560@TK2MSFTNGP04.phx.gbl...
>> Dear all,
>>
>> I'm using MDW file in my application.
>> After the user login, can I know the password of CurrentUser() ?
>> Thanks.
>>
>> Regards
>> Vensia
>>
>>
>
Author
5 Nov 2006 8:46 PM
David W. Fenton
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
news:#zdjqGNAHHA.4672@TK2MSFTNGP02.phx.gbl:

> 1) There's no connection between CurrentUser in Access and
> whatever has been defined in ActiveDirectory.
>
> 2) Your code samples are .Net, whereas Access uses VBA.

3) There is no way in any security system to retrieve the password
from a user account. If there were, they wouldn't be "security
systems".

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/
Author
5 Nov 2006 9:38 PM
Douglas J. Steele
"David W. Fenton" <XXXuse***@dfenton.com.invalid> wrote in message
news:Xns9872A0701BA81f99a49ed1d0c49c5bbb2@127.0.0.1...
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
> news:#zdjqGNAHHA.4672@TK2MSFTNGP02.phx.gbl:
>
>> 1) There's no connection between CurrentUser in Access and
>> whatever has been defined in ActiveDirectory.
>>
>> 2) Your code samples are .Net, whereas Access uses VBA.
>
> 3) There is no way in any security system to retrieve the password
> from a user account. If there were, they wouldn't be "security
> systems".

I didn't think it was necessary to point out the obvious. <g>

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Author
6 Nov 2006 11:29 PM
Nip
Hi NG
Sorry, I just had read some network stuff in another group and was
programming .net besides it, so I mixed things up.
Bye Nip


Show quote
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:O7%23ZFLSAHHA.3836@TK2MSFTNGP02.phx.gbl...
> "David W. Fenton" <XXXuse***@dfenton.com.invalid> wrote in message
> news:Xns9872A0701BA81f99a49ed1d0c49c5bbb2@127.0.0.1...
>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
>> news:#zdjqGNAHHA.4672@TK2MSFTNGP02.phx.gbl:
>>
>>> 1) There's no connection between CurrentUser in Access and
>>> whatever has been defined in ActiveDirectory.
>>>
>>> 2) Your code samples are .Net, whereas Access uses VBA.
>>
>> 3) There is no way in any security system to retrieve the password
>> from a user account. If there were, they wouldn't be "security
>> systems".
>
> I didn't think it was necessary to point out the obvious. <g>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>

AddThis Social Bookmark Button