change user password

[marcuu]

how to change users passwords in VB but not i SQL ?

[MMcCarthy]

how to change users passwords in VB but not i SQL ?

Is this an Access or a VB question? Please provide more information.

Mary

[marcuu]

Microsoft Access

[MMcCarthy]

Microsoft Access

Without more information the best I can do is point you in the direction of this website.

http://www.jmwild.com/Accesssecurity.htm


Mary

[marcuu]

omg
i need a code in visual basic to change users passwords on usersecurity level in Ms access
i dont need an instruction how to run a creator but a vb code!
in sql thath code is

ALTER USER <UserName> PASSWORD <NewPassword> <OldPassword>

i need something like this but in Vb now you get it ?

[MMcCarthy]

omg
i need a code in visual basic to change users passwords on usersecurity level in Ms access
i dont need an instruction how to run a creator but a vb code!
in sql thath code is

ALTER USER <UserName> PASSWORD <NewPassword> <OldPassword>

i need something like this but in Vb now you get it ?

Marcuu

You have given very little information so far and we're not psychic so please don't be rude.

Where is the user table? Is it in Access or in a SQL backend. Is the security you are asking about the SQL level security or a linked table in Access?

Mary

[marcuu]

learn how to reply from ADezii
i have found the code on google groups

Public Function ChangePassword(strUser As String, _
        strOldPassword As String, strNewPassword As String)
    Dim wrk As DAO.Workspace
    Dim usr As DAO.User
 
 
    Set wrk = DBEngine(0)
    Set usr = wrk.Users(strUser)
 
    'Change the password
    usr.NewPassword strOldPassword, strNewPassword
 
    Set usr = Nothing
    Set wrk = Nothing
End Function
 
 

[MMcCarthy]

I'm glad you found the code. And I'm sorry you feel unable to apologise for your rudeness. Please don't expect me to attempt to answer any future questions from you.

[NeoPa]

Marcuu,
Not being able to speak the language well is no excuse for your rudeness.
We welcome all sorts on this web site, but most people - even the fairly ignorant ones - have at least the sense to be polite to those donating their free time to help them.
If this is beyond your capability then don't expect too much help here.

MODERATOR.