RE: Compare 2 Tables and then Update so they match
Sure.<BR><BR>Open the connection to the db.<BR><BR>Open table1 and get the field values close the rs<BR>Open table 2<BR><BR>Then write your IF-Then statements to compare the 2 and make them = if they are different. <BR><BR>But why would you want 2 identical records in 2 different tables??? What am I missing here?
Do you have your answer from my post above or will that not work? I guess I'm dense. If table1 has "tons of data" and table 2 stores only 3 fields: Username, Password and an ID the what is it that you are comparing???