by There are 3 problems that I can't resolve to let users let administrate
there own account. All of them have to do with the passwords the users have
to enter when they want to log on to a Access DB through a ODBC connection.
1st problem:
To be able to change a password you first have to change to property
'SystemDB' of the DBEngine object to the 'mdw'-file your system is using for
the user accounts. But when the program is using a ODBC connection, the
database location and the location of the system database are stored in the
ODBC connection. Is there a possibility to get the database locations from
the ODBC connection or is there an other solution to change a password?
2nd problem:
Normally a administrator can reset the password of any user without knowing
there password. This action is also possibly in MS Access, but DAO only
gives the opportunity to change a password when the old one is entered
correctly:
DBEngine.Workspaces(0).Users(varUserName).NewPassword varOldPassword,
varNewPassword
I didn't find any method to reset a password of a user. What can I do to
make this function available in my program.
3rd problem:
After I changed the password of the 'admin'-user, I'm still able to logon to
the database using the new password. But when I want to use any method of
the DBEngine.Workspaces(0), I receive an error saying that the username or
the password is invalid.
This problem doesn't occur for any other user. Is there an explanation for
this phenomenon?
If someone knows an answer to any of these problems, I will be very pleased
with the possible solution!
Thanks in advance.
Tom