I have posted this in the database section as well.. sorry, but I really need an answer to this one.

Here's the scenario,
I have a VB front end that accesses the security workgroup file (MDW) of a database.
The VB front end requires the users to login, this then open a connection via ADO to verify the user and does a lot of error checking. I wrote this because the login dialog box to access is crap.
Anyhow, I have a menu option in the front end that allows the users to change thier password to the workgroup because I have disabled this feature in the access database itself.... but that's all I have. I am not sure how to code this in VB.
I know how to do it for a database password but not for individual users. Any help would be appreciated and remember I am using ADO not DAO.

Thanks,
Mega_Man.