Access 2000 - Can Users Change Their Own Passwords?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
Back
Top