I have a # temp table and want to insert the record thru vb ado control but fail. pls advise how to use recordset.update to update against # temp table.

e.g
Dim ars As New ADODB.Recordset

ars.CursorLocation = adUseServer
ars.Open "#email", <connenction>, adOpenKeyset, adLockOptimistic, adCmdTable

ars.AddNew
...
ars.update
==> the following error msg return
"Query cannot be updated because the FROM clause is not a single simple table name."