Change Password command
yet, so I'll try here.
Using Access user-level security: I have a button on a form which opens the
User and Group Accounts dialog, via the following code:
I also have a function which returns True if the current user is a member of
the admins group. What I would like to do is, if the user is not in the
admins group, to open the User and Group Accounts dialog with the Change
Password tab selected (since the Users tab doesn't have many usable options,
and what I really want is to allow users to change their password as easily
(How) can I force the Change Password tab to be selected when the User and
Group Accounts dialog is opened?
Not to answer your question, but: In my opinion the standard security
interface is hard to understand. If you want your users to be able to
change their own passwords, why not just write a form for this? Have a
textbox for the old password, one for the new, and another to repeat
the new one. Then, in code attache to a "Change it now!" button, use
the NewPassword() method to actually make the change.
With that approach, you needn't display the standard security
interface, at all.
TC [MVP Access]
Other interesting topics
Transfer Database into Protected project
Replication ***PLEASE HELP***
What MS Access version to use?
/wrkgrp switch won't work
ms access username password issue
Replication & Security
Is there a way better than Password
Access 2000 Security
Linking a unsecured database to a table in a secure database