Hi I keep getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression '" WHERE id=229'.
My SQL statement is as follows:
SQL = "UPDATE Table SET Field1 = "", Field2 = "", Field3 = "" WHERE id="&id
ID is an autonumber field and I was under the impression until now that was syntax.