changing passwords

I need to build an .exe. This program will search the database for a specific user_login and make that users password=Null.


How would I begin this. I am reletivitly inexerpeiced to Db connections. I know i will have to extablish an ODBC connectioon.

PLeas help

[Clunietp]

you could try something like this using ado:

dim cn as new connection
cn.open <connectionstringhere>
cn.execute "update tablenamewithusersandpasswords set password = '' where username = 'bob'"
cn.close

it establishes a connection to your database, executes a SQL statement to set the password to a zero length string/null, and closes the connection.

HTH

Tom