I'm trying to update many records in a database with the following statement.
Seams it isn't going to be as easy as...


Update = "UPDATE vpo STATUS=PENDING WHERE STATUS=APPROVED"
Conn.Execute( Update)


I get this error..

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
line 9


Line 9 is the update statement, any one have some easy other ways to do this?

As the error indicates, the syntax of your SQL is wrong. I note you've posted update SQL on other threads with the correct syntax, so you may want to revisit that (hint: SET). I'd guess you're also going to need single quotes around PENDING and APPROVED.

Wow.. guess I'd been coding for too long, I can't believe I missed that.. Thanks.