Printable View
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
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