See
http://www.aspfaq.com/show.asp?id=2400
| Thanks Thomas for responding, what I mean is i make a DB using DBIW in
| FP2003. It has the "key" field, then a "number field, and the rest are text
| fields as many as 25 in all. I set the "number" field as a text box, and set
| a default value for all fields. After building the db, entering values into
| each field, and hit enter, the db results fine, but I go back into the
| editor, click "edit" a record, make a change, then hit enter and I get the
| error
| ""Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine"
|
| Last night I went to Kathleen Andersons site, and followed a link that she
| has there for the first error message that I was getting, so I did a search @
| MS for the second error message and it brought up a result, but I haven't had
| a chance today to go back there & research it, but I will later.
|
| Mike
|
|
|
| "Thomas A. Rowe" wrote:
|
| > Please explain "but when I make one the way I wan't it, it goofs up"
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| >
http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > >I am puzzled........I have deleted and started over 3 or 4 times, re-making
| > > the database with DBIW, and each time I get that same error message as in my
| > > prev. post. I made one database without adding any new fields, and upon
| > > completion, that one works fine with no errors, but when I make one the way I
| > > wan't it, it goofs up. I am adding about 20 fields, and upon completion I
| > > have to edit that file you told me to, then I get the second eroor and the DB
| > > does not update if I "edit" a record. I can make a new record ok, I just
| > > can't edit one
| > >
| > > Mike
| > >
| > > "Kathleen Anderson [MVP - FrontPage]" wrote:
| > >
| > >> The FP2003 code has changed slightly. To see the true error, open the hidden
| > >> folder /_fpclass/ and edit the fpdbrgn1.inc file
| > >>
| > >> At about line 19, change :
| > >>
| > >> fp_DEBUG = False
| > >>
| > >> to :
| > >>
| > >> fp_DEBUG = True
| > >>
| > >>
| > >> --
| > >> ~ Kathleen Anderson
| > >> Microsoft MVP - FrontPage
| > >> Spider Web Woman Designs
| > >> web:
http://www.spiderwebwoman.com/resources/
| > >>
| > >>
| > >> | > >> > ok, I made a database, entered some data into the fields using the
| > >> > database
| > >> > editor, then I tried to edit one of the records, and got this message
| > >> > Database Results Wizard Error
| > >> > The operation failed. If this continues, please contact your server
| > >> > administrator.
| > >> >
| > >> > I since have shut everything down, and re-booted, re-connected to the
| > >> > server, but it still does it, what am I doing wrong?
| > >>
| > >>
| > >>
| >
| >
| >