how to change MS Access mdw password using ASP code 2

[axslearnr]

Hi
I have ASP page where I have a form to change the password of the user. The back end is Access database and I dont have any tables for password information. I have a workgroup information file for the users.

How to change the password of the access database using ASP form.

pls let me know
thank you.

 

[CassidyHunt]

Can you omit the on error resume next? I am curious if you have ADOX loaded on your machine.

 

[axslearnr]

Thank you very much for our help.

I omit the error next resume. Its still like that? what is ADOX?

Pls let me know
bye

 

[axslearnr]

Hi
I go this eror message now

Error Type:
Provider (0x800A0CB3)
Object or provider is not capable of performing requested operation.
/ChangePasswordADO.asp, line 46

line 46 : cat.Users("kumar").ChangePassword "", "ybnvdp"

pls let me know

thank you

 

[DreXor]

is the "" by itself old password perchance? and perchance necessary?

DreX
aKa - Robert

 

[axslearnr]

Hi
" " is old password only. it didnt work. it say object not supported is it bcos of ADOX? how to see whether i have ADOX or not in my computer?

Do i have install ADOX on every computer for all users ?

pls let me know
thank you

 

[CassidyHunt]

I think your right. Needs to be this:

cat.Users("kumar").ChangePassword "oldpassword", "ybnvdp"

I didn't have a password on mine to start with. Sorry about that. Nice catch Drexor.

 

[CassidyHunt]

You should be able to open up the registry and do a search for ADOX.Catalog. If you find a key that says that then your fine. However it there you have seems to think you have ADOX installed fine. Just not giving the right information.

Let me know if the previous post worked.

Cassidy

 

[axslearnr]

Hi
I still get the same error at that line. I really appreciate u guys helping me. I am sorry I am not that good in ASP. Pls let me know

thank you


Error Type:
Provider (0x800A0CB3)
Object or provider is not capable of performing requested operation.
/ChangePasswordADO.asp, line 46

 

[axslearnr]

Hi
Thank for your help. I really appreciate it. That code worked to change the password.

Thank you

 

[DreXor]

another satisfied customer!


axs, it would be gracious of you to give cassidy a star for his hard work on this.

DreX
aKa - Robert

 

[DreXor]

SCRATCH that, the star snuck in while i was typing

DreX
aKa - Robert

 

[axslearnr]

Hi
I gave a star to Cassidy on this topic.

Thanks

 

[CassidyHunt]

Thanks for the star. So I assume you got it to work. Good job.