Update query syntax in MS Access

[chaitanya02]

Hi All,

Please help me in telling how the update query works with MS access when called from asp page.

I have fourtables in MS Access, I want to compare v2 from table 2 with v2 fromtable 3, if they are same- i will send an email: if they are not thhe same then we have to update table3.v2 with table 2.v2

Please help....

thanks,
tanya

[shweta123]

Hi,

Dim rs
Dim v2
Dim v3
Sql = "Select v2 from table2
set rs = con.Execute(Sql )
v2 = rs("v2")
rs.close

Sql = "Select v2 from table3
set rs = con.Execute(Sql )
v3 = rs("v3")

if v2 <> v3 then
sql="Update table3 set v2 =" & v3 &""
con.execute(sql )
end if

Hi All,

Please help me in telling how the update query works with MS access when called from asp page.

I have fourtables in MS Access, I want to compare v2 from table 2 with v2 fromtable 3, if they are same- i will send an email: if they are not thhe same then we have to update table3.v2 with table 2.v2

Please help....

thanks,
tanya