Changing Access password with ADO

I'm using ADO 2.0 to connect to an Access 97 database (with security) through an ODBC System DSN. It's working fine.

I would like to know how to change a user's password with ADO.

Is it possible, if so, how do I do that ?
mxcloutiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
altenaConnect With a Mentor Commented:
The answer to the original question:
"how to change a user's password with ADO"

No, this is not a feature of ADO. And the path this question
has taken is a hack. As soon as you get it to work, your
application will break whenever a new version of access is
installed. (if you get it to work in the first place)

The answer to the question:
"How do I allow the user to change the password?"

For access databases, use DAO and call User.Newpassword
(but you knew this, off course)

The changing of passwords is not standardized, so you have
to use the "standard method" of the database you are using.
With Access databases, that means DAO.

    Good Luck

0
 
vmanoCommented:
ADO Data Control has Password Property which Sets the password used during creation of an ADO Recordset object.

Syntax - object.Password [= string]

object - An object expression that evaluates to an object... for example an ADO data control
string - Sets the password for the user named in the UserName property.

This property setting is write-only — it may only be provided in code, it cannot be read back from the Password property.

let me know if this helps
vmano
0
 
mxcloutiAuthor Commented:
I'm not using the ADO Data Control and I don't want to.

I'm using Microsoft ActiveX Data Objects 2.0 Library (MSADO15.DLL)

I'm connecting to my Access Database (with security) this way:

Dim conADO As ADODB.Connection
Set conADO = New ADODB.Connection
conADO.Open "DSN=WMS_REL;UID=mxclouti;PWD=mxclouti;"

where WMS_REL is an ODBC SYSTEM DSN pointing to my Access Database WMS_REL.MDB. I' m also using the system database WMS_REL.MDW for the security.

Once the user is connected to the database, I want him to be able to change his password:

Old password: xxxxx
New password: xxxxx
Verification: xxxxx
(OK) (CANCEL)

I'm waiting for your answer.

Thanks
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
mxcloutiAuthor Commented:
Now I know that:

Users and passwords are included in the table msysAccounts of WMS_REL.MDW. Fieldnames are FGroupe, Name, Password and SID.

So, it's very easy to connect to WMS_REL.MDW with ADO and change the password.

But I need to provide and encrypted password.

The question is, how do I encrypt the new password before updating the field Password where Name = "mxclouti".

Thanks in advance.
0
 
vmanoCommented:
check out the EE article
http://experts-exchange.com/topics/comp/lang/visualbasic/Q.10086508

about "making a password" answered by Waty.
0
 
mxcloutiAuthor Commented:
Article http://experts-exchange.com/topics/comp/lang/visualbasic/Q.10086508 shows how to encrypt a password. Ok

But, is it the same encryption algorithm that is used to encrypt the password field in msysAccounts in my .MDW file.

Thanks.

0
 
vmanoCommented:
I am not sure.
0
 
mxcloutiAuthor Commented:
Is it possible to change a password in the table msysAccounts of a .MDW file ? The field Password is an encrypted field.
0
 
mxcloutiAuthor Commented:
I'll be using USER.NEWPASSWORD then.

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.