Hi,
You can use your preferred way to update the password stored in the
field, the database is not aware that there is something special about that
given field. You may have to encrypt the database to not be allow the
password to be easily readable from the mdb file open as a binary file.
To be sure the right user is modifying the right record, you may ask the
user to type the actual password, compare it, and if the comparison agree,
allow the user to change the password.
Since there are many ways to bypass such a home maid password
protection, I would rather not do it. If possible, use the integrated Access
security, rather than using your own.
Hoping it may help,
Vanderghast, Access MVP
