January 10, 2003. Updated Access 97/2000+ version is available (with bug fixes!)
Password Changer is a simple utility for Access
database administrators using workgroup security. It has two sample forms: one lets all users in your application
change their own passwords. The other form is for database
administrators to change or clear any user's password. Just follow a few steps
and they are ready to use in your secure application.
(Note: this utility manages passwords for Access workgroup security, not database passwords or Windows/NT security)
Download old version for Access 2.0 (22k) - Download Updated 97/2000+ (38k)
Update January 10, 2003 - Major bug fixes and some appearance and functionality changes.
Update May 4,2002
Prior versions of Password Changer may not compile correctly in Access 2000/XP.
Either download the updated version above, or follow these instructions to make the simple code fix.
To use the prior Access 97 version in your 2000 database, you need to do the following:
Add a reference in your application to DAO (Microsoft Data Access Objects 3.6). To do this,
view any code in your app, choose Tools-References from the menubar, then scroll down and check
this reference.
In the code behind the administrator form, find the sub called "RefreshUserList_Click".
Edit two lines here to look like:
Dim MyWorkspace As DAO.Workspace
Dim TempUser As DAO.User
Finally, choose Debug-Compile.. to make sure your app compiles correctly. That's it.
The Administrators form below shows a list of all users in the secure workgroup, and you can change or clear any of their passwords -- all from this one screen. You don't need to log in as each user just to set their password.
The Users form below is a simple screen for users to change their own password. It will work fine for runtime 97 users who can't see the database window. Its also better than the RunCommand technique in Access 97 which opens the tabbed dialog of groups and users -- information you may not want your users to see.
