Hi everyone,
I have a database that has 3 Tables, none of them are linked together.[/b]

This is the Structure of the Database


Table1
Table1_Field1
Table1_Field2
Table1_Field3
USER_NAME


Table2
Table2_Field1
Table2_Field2
Table2_Field3
USER_NAME


Table3
Table3_Field1
Table3_Field2
Table3_Field3
USER_NAME


If you notice, USER_NAME is common in the 3 tables. Now here is the question. What is the easiest way to change the value for USER_NAME from Tom to Harry, in all the 3 tables?

P.S. I'm using ADO