Hi everyone,

I have a database that has 3 Tables, none of them are linked together.

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

[Edited by omarswan on 05-30-2000 at 04:09 PM]