I tried looking online for some info on Access SQL syntax. What's the format for an Access SQL Update statement to update a row in the table?
...and there aren't any good ones for Access2000 or Access2002.<BR><BR>Use the Access97 ones:<BR><BR>http://msdn.microsoft.com/library/en-us/office97/html/output/F1/D2/S5A33D.asp<BR><BR>
He asked for *SQL Statement*, not the ADO way of doing it.<BR><BR>And if possible you should usually avoid the ADO way, as it's slow and clumsy in comparison. (A few places where it wins--such as updating blobs.)<BR><BR>