Error help

[Paul M]

Hi
I am recieving this error message when I try to update
records with the database editor

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine


Any ideas
Best wishes
Paul M

 

[=?Windows-1252?Q?Rob_Giordano_\=28aka:_Crash_Gordo]

Make sure you dont have a field name that is a reserved word.


| Hi
| I am recieving this error message when I try to update
| records with the database editor
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
|
| Any ideas
| Best wishes
| Paul M
|

 

[Paul M]

Hi
Where can I find a list of reserved words
Paul M

-----Original Message-----
Make sure you dont have a field name that is a reserved word.


"Paul M" <[email protected]> wrote in

message news:[email protected]...

 

[Kathleen Anderson [MVP - FrontPage]]

http://pacosdrivers.com/asp/reserved/ (watch out for the pop ups).

 

[=?Windows-1252?Q?Rob_Giordano_\=28aka:_Crash_Gordo]

here's some more without the pesky popups

http://support.microsoft.com/default.aspx?scid=kb;EN-US;321266


| http://pacosdrivers.com/asp/reserved/ (watch out for the pop ups).
|
| --
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| http://www.spiderwebwoman.com/resources/
|
|
| > Hi
| > Where can I find a list of reserved words
| > Paul M
| >> -----Original Message-----
| >> Make sure you dont have a field name that is a reserved word.
| >>
| >>
| > message | >>> Hi
| >>> I am recieving this error message when I try to update
| >>> records with the database editor
| >>>
| >>> Database Results Wizard Error
| >>> Description: Syntax error in UPDATE statement.
| >>> Number: -2147217900 (0x80040E14)
| >>> Source: Microsoft JET Database Engine
| >>>
| >>>
| >>> Any ideas
| >>> Best wishes
| >>> Paul M
| >>>
| >> .

 

[Paul M]

Hi thanks for your help
It was the timestamp field that the wizard adds,when I
removed it it worked. Strange?

-----Original Message-----
here's some more without the pesky popups

http://support.microsoft.com/default.aspx?scid=kb;EN- US;321266


"Kathleen Anderson [MVP - FrontPage]"