Database Results Wizard Error

[John Parker]

I have set up a form feeding a database but when I use the DRW to try edit I
get the following message.

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I have double checked all the field names to make sure there is no name
conflicts.. Is there a way I can get more details of the error?

John P.

 

[John Parker]

I am struggling with this. I can add a new record okay, but when I try to
edit I keep getting the error!!

 

[John Parker]

I managed to expand the error and it now reads:

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

 

[Stefan B Rusynko]

See http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e14-errors.html

Post your UPDATE statement
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I managed to expand the error and it now reads:
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
|
|
|
|
|
| | >I have set up a form feeding a database but when I use the DRW to try edit
| >I get the following message.
| >
| > Database Results Wizard Error
| > The operation failed. If this continues, please contact your server
| > administrator.
| >
| > I have double checked all the field names to make sure there is no name
| > conflicts.. Is there a way I can get more details of the error?
| >
| > John P.
| >
|
|

 

[John Parker]

Thanks Stefan, I found my problem. I was using "Date" as a field name which
I forgot was allocated.

I appreciate you getting back though.

John P.