When you use reserved words (e.g.: "name") as table or column names, you
need to wrap them in square brackets when using them in a Jet SQL statement.
UPDATE Clients SET [number] = 300, [name] = 'Ace Lock', address1 = ...
This allows the Jet SQL engine to recognize the names as identifiers rather
than mis-use of the reserved words. Of course, an even better approach is
to not use reserved words as table/column names in the first place...
"TomD" <dcbcadmgr.nospam.> wrote in message
news:uwKThJj8DHA.2404TK2MSFTNGP11.phx.gbl...> The following SQL statement is resulting in the error after it:
> (pasted from IE window)
> UPDATE Clients SET number = 300, name = 'Ace Lock', address1 = 'add1',
> address2 = 'add2', city = 'city', state = 'pa', zip = '15222' WHERE id =
> Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft
> JET Database Engine Description: Syntax error in UPDATE statement. in
> c:\inetpub\wwwroot\kdaclients.php on line 40
> When I take out the number and name fields, it works fine
> UPDATE Clients SET address1 = 'add1', address2 = 'add2', city = 'city',
> state = 'pa', zip = '15222' WHERE id = 1;
> The number field is a number, the rest are text fields. Any input