> I'm working on a split multi-user, secured db with 3 groups (built-in
> Read-Only, Full-Data, and Admins).  I was hoping to allow them all to
> change their own passwords, but the ReadOnly and FullData groups
> don't have access to System tables to make the change (No Read
> permission on MsysUserList). - Can I somehow allow users to change
> their own passwords?

"Joan Wild" wrote:

> There is sample code in the security FAQ.  Basically you provide a form with
> some textboxes for the user to supply the old password, and new password,
> and username (which could be displayed using CurrentUser() function.  Use
> the code in the FAQ to change the password.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> bigpalooka wrote:
> > I'm working on a split multi-user, secured db with 3 groups (built-in
> > Read-Only, Full-Data, and Admins).  I was hoping to allow them all to
> > change their own passwords, but the ReadOnly and FullData groups
> > don't have access to System tables to make the change (No Read
> > permission on MsysUserList). - Can I somehow allow users to change
> > their own passwords?
>
>
>

> I've got similar code already.  It works fine for the Admins group,
> but not Full Data or Read-Only groups.  It's getting hung up on the
> MSysUserList table (Error 3112 - Record Cannot be read. No permission
> on MSysUserList table)
> - Is there a way to get a non-Admin user to at least read the
> MSysUserList and MSysGroupList tables?
> - Are these tables normally readable by non-Admin users?  If that's
> the case, I've got to hunt down where I may have set these.
>
> jp
>
> "Joan Wild" wrote:
>
>> There is sample code in the security FAQ.  Basically you provide a
>> form with some textboxes for the user to supply the old password,
>> and new password, and username (which could be displayed using
>> CurrentUser() function.  Use the code in the FAQ to change the
>> password.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> bigpalooka wrote:
>>> I'm working on a split multi-user, secured db with 3 groups
>>> (built-in Read-Only, Full-Data, and Admins).  I was hoping to allow
>>> them all to change their own passwords, but the ReadOnly and
>>> FullData groups don't have access to System tables to make the
>>> change (No Read permission on MsysUserList). - Can I somehow allow
>>> users to change their own passwords?