i would think you'd need a loop in there somewhere to loop through all the records. As of now it's doing exactly what it should - update one record.
I am trying to update all recors in one table with records from another table. My script is only updating one record. How do I fix this? This is what I have:
set rec1=con.execute ("SELECT * FROM Cancels ORDER BY Canceldate ASC")
rec2 = "update FC2003copy SET LPCancelDate = '" & rec1("canceldate") & "'" & _
"where CaseNum= '" & rec1("CaseNum") & "'"
Con.Execute(rec2)

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic