hi...i've been trying to update a temp table to another table and it doesn't want to work...im using asp as the scripting lang. and access as the db...here is what i have...

<%
Dim name, email, comments
Dim sConnString, connection, sSQL

sSQL = "update t1
set name = '" & t2.name & "'
from users_tbl t1 inner join tempusers_tbl t2"

sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("users.mdb" & ";"

Set connection = Server.CreateObject("ADODB.Connection"

connection.Open(sConnString)

connection.execute(sSQL)

connection.Close
Set connection = Nothing
%>

thanks for your time...