I have used the DIW to add a database maintenance function to my web. The
results will allow me to add a record, delete a record and view records but
it will not allow me to edit a record.
When I open a record for editing it allows me to make changes but when the
OK button is clicked the following error message pops up.

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

I get to this point by opening the List page and displaying the record set.
I double click on a record to open the detail page and click edit to open the
edit page. After making the changes I click the OK button and the error
message displays.
Help please

Can you post your SQL (the UPDATE statement)?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




"kyleq" <(E-Mail Removed)> wrote in message
news:371ACF21-E2A0-445F-AF3E-(E-Mail Removed)...
>I have used the DIW to add a database maintenance function to my web. The
> results will allow me to add a record, delete a record and view records
> but
> it will not allow me to edit a record.
> When I open a record for editing it allows me to make changes but when the
> OK button is clicked the following error message pops up.
>
> "Database Results Wizard Error
> Description: Syntax error in UPDATE statement.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
>
> I get to this point by opening the List page and displaying the record
> set.
> I double click on a record to open the detail page and click edit to open
> the
> edit page. After making the changes I click the OK button and the error
> message displays.
> Help please
>

Thanks for the response Kathleen.
I don't know what "post your SQL (the UPDATE statement)?" means.
The only Post reference in the edit.asp code looks like this:

<!--webbot bot="DatabaseRegionStart" endspan i-checksum="50178" --> <form
METHOD="POST" action="update.asp" onsubmit="return
FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">

It is the FrontPage generated script and I assume it cannot complete.
Kyleq



"Kathleen Anderson [MVP - FrontPage]" wrote:

> Can you post your SQL (the UPDATE statement)?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
> FrontPage Support: http://www.frontpagemvps.com/
>
>
>
>
> "kyleq" <(E-Mail Removed)> wrote in message
> news:371ACF21-E2A0-445F-AF3E-(E-Mail Removed)...
> >I have used the DIW to add a database maintenance function to my web. The
> > results will allow me to add a record, delete a record and view records
> > but
> > it will not allow me to edit a record.
> > When I open a record for editing it allows me to make changes but when the
> > OK button is clicked the following error message pops up.
> >
> > "Database Results Wizard Error
> > Description: Syntax error in UPDATE statement.
> > Number: -2147217900 (0x80040E14)
> > Source: Microsoft JET Database Engine
> >
> > I get to this point by opening the List page and displaying the record
> > set.
> > I double click on a record to open the detail page and click edit to open
> > the
> > edit page. After making the changes I click the OK button and the error
> > message displays.
> > Help please
> >
>
>
>

In the page "update.asp", in Code View, you should see a statement that
starts this way:
fp_sQry="UPDATE



--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




"kyleq" <(E-Mail Removed)> wrote in message
news18B5CA2-5D02-4DF3-AB35-(E-Mail Removed)...
> Thanks for the response Kathleen.
> I don't know what "post your SQL (the UPDATE statement)?" means.
> The only Post reference in the edit.asp code looks like this:
>
> <!--webbot bot="DatabaseRegionStart" endspan i-checksum="50178" --> <form
> METHOD="POST" action="update.asp" onsubmit="return
> FrontPage_Form1_Validator(this)" language="JavaScript"
> name="FrontPage_Form1">
>
> It is the FrontPage generated script and I assume it cannot complete.
> Kyleq
>
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> Can you post your SQL (the UPDATE statement)?
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>> FrontPage Support: http://www.frontpagemvps.com/
>>
>>
>>
>>
>> "kyleq" <(E-Mail Removed)> wrote in message
>> news:371ACF21-E2A0-445F-AF3E-(E-Mail Removed)...
>> >I have used the DIW to add a database maintenance function to my web.
>> >The
>> > results will allow me to add a record, delete a record and view records
>> > but
>> > it will not allow me to edit a record.
>> > When I open a record for editing it allows me to make changes but when
>> > the
>> > OK button is clicked the following error message pops up.
>> >
>> > "Database Results Wizard Error
>> > Description: Syntax error in UPDATE statement.
>> > Number: -2147217900 (0x80040E14)
>> > Source: Microsoft JET Database Engine
>> >
>> > I get to this point by opening the List page and displaying the record
>> > set.
>> > I double click on a record to open the detail page and click edit to
>> > open
>> > the
>> > edit page. After making the changes I click the OK button and the
>> > error
>> > message displays.
>> > Help please
>> >
>>
>>
>>

This is what that statement looks like. PhoneNumber is the key.
KyleQ
<%
fp_sQry="UPDATE Results SET Name = '::Name::' , Title = '::Title::' ,
Organization = '::Organization::' , City = '::City::' , Zip = '::Zip::' ,
Email = '::Email::' , WebSite = '::WebSite::' , Affiliation =
'::Affiliation::' , Category = '::Category::' , ShortDesc = '::ShortDesc::' ,
FullDesc = '::FullDesc::' , Password = '::Password::' , DateAdded =
':ateAdded::' WHERE (PhoneNumber = ::PhoneNumber:"



"Kathleen Anderson [MVP - FrontPage]" wrote:

> In the page "update.asp", in Code View, you should see a statement that
> starts this way:
> fp_sQry="UPDATE
>
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
> FrontPage Support: http://www.frontpagemvps.com/
>
>
>
>
> "kyleq" <(E-Mail Removed)> wrote in message
> news18B5CA2-5D02-4DF3-AB35-(E-Mail Removed)...
> > Thanks for the response Kathleen.
> > I don't know what "post your SQL (the UPDATE statement)?" means.
> > The only Post reference in the edit.asp code looks like this:
> >
> > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="50178" --> <form
> > METHOD="POST" action="update.asp" onsubmit="return
> > FrontPage_Form1_Validator(this)" language="JavaScript"
> > name="FrontPage_Form1">
> >
> > It is the FrontPage generated script and I assume it cannot complete.
> > Kyleq
> >
> >
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> Can you post your SQL (the UPDATE statement)?
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> web: http://www.spiderwebwoman.com/resources/
> >> FrontPage Support: http://www.frontpagemvps.com/
> >>
> >>
> >>
> >>
> >> "kyleq" <(E-Mail Removed)> wrote in message
> >> news:371ACF21-E2A0-445F-AF3E-(E-Mail Removed)...
> >> >I have used the DIW to add a database maintenance function to my web.
> >> >The
> >> > results will allow me to add a record, delete a record and view records
> >> > but
> >> > it will not allow me to edit a record.
> >> > When I open a record for editing it allows me to make changes but when
> >> > the
> >> > OK button is clicked the following error message pops up.
> >> >
> >> > "Database Results Wizard Error
> >> > Description: Syntax error in UPDATE statement.
> >> > Number: -2147217900 (0x80040E14)
> >> > Source: Microsoft JET Database Engine
> >> >
> >> > I get to this point by opening the List page and displaying the record
> >> > set.
> >> > I double click on a record to open the detail page and click edit to
> >> > open
> >> > the
> >> > edit page. After making the changes I click the OK button and the
> >> > error
> >> > message displays.
> >> > Help please
> >> >
> >>
> >>
> >>
>
>
>

NAME is a reserved word in Access 2002 and Access 2003
http://support.microsoft.com/default...b;en-us;286335 you need to
change it to something else.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"kyleq" <(E-Mail Removed)> wrote in message
news:F1096F4D-F032-47A9-B165-(E-Mail Removed)...
> This is what that statement looks like. PhoneNumber is the key.
> KyleQ
> <%
> fp_sQry="UPDATE Results SET Name = '::Name::' , Title = '::Title::' ,
> Organization = '::Organization::' , City = '::City::' , Zip = '::Zip::' ,
> Email = '::Email::' , WebSite = '::WebSite::' , Affiliation =
> '::Affiliation::' , Category = '::Category::' , ShortDesc =
> '::ShortDesc::' ,
> FullDesc = '::FullDesc::' , Password = '::Password::' , DateAdded =
> ':ateAdded::' WHERE (PhoneNumber = ::PhoneNumber:"
>
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> In the page "update.asp", in Code View, you should see a statement that
>> starts this way:
>> fp_sQry="UPDATE
>>
>>
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>> FrontPage Support: http://www.frontpagemvps.com/
>>
>>
>>
>>
>> "kyleq" <(E-Mail Removed)> wrote in message
>> news18B5CA2-5D02-4DF3-AB35-(E-Mail Removed)...
>> > Thanks for the response Kathleen.
>> > I don't know what "post your SQL (the UPDATE statement)?" means.
>> > The only Post reference in the edit.asp code looks like this:
>> >
>> > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="50178" -->
>> > <form
>> > METHOD="POST" action="update.asp" onsubmit="return
>> > FrontPage_Form1_Validator(this)" language="JavaScript"
>> > name="FrontPage_Form1">
>> >
>> > It is the FrontPage generated script and I assume it cannot complete.
>> > Kyleq
>> >
>> >
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> >> Can you post your SQL (the UPDATE statement)?
>> >>
>> >> --
>> >>
>> >> ~ Kathleen Anderson
>> >> Microsoft MVP - FrontPage
>> >> Spider Web Woman Designs
>> >> web: http://www.spiderwebwoman.com/resources/
>> >> FrontPage Support: http://www.frontpagemvps.com/
>> >>
>> >>
>> >>
>> >>
>> >> "kyleq" <(E-Mail Removed)> wrote in message
>> >> news:371ACF21-E2A0-445F-AF3E-(E-Mail Removed)...
>> >> >I have used the DIW to add a database maintenance function to my web.
>> >> >The
>> >> > results will allow me to add a record, delete a record and view
>> >> > records
>> >> > but
>> >> > it will not allow me to edit a record.
>> >> > When I open a record for editing it allows me to make changes but
>> >> > when
>> >> > the
>> >> > OK button is clicked the following error message pops up.
>> >> >
>> >> > "Database Results Wizard Error
>> >> > Description: Syntax error in UPDATE statement.
>> >> > Number: -2147217900 (0x80040E14)
>> >> > Source: Microsoft JET Database Engine
>> >> >
>> >> > I get to this point by opening the List page and displaying the
>> >> > record
>> >> > set.
>> >> > I double click on a record to open the detail page and click edit to
>> >> > open
>> >> > the
>> >> > edit page. After making the changes I click the OK button and the
>> >> > error
>> >> > message displays.
>> >> > Help please
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Hi Kathleen,
I changed the field from NAME to FULLName and regenerated the forms with
DIW with the same results. If you have other ideas I would appreciate them.
KyleQ

"Kathleen Anderson [MVP - FrontPage]" wrote:

> NAME is a reserved word in Access 2002 and Access 2003
> http://support.microsoft.com/default...b;en-us;286335 you need to
> change it to something else.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "kyleq" <(E-Mail Removed)> wrote in message
> news:F1096F4D-F032-47A9-B165-(E-Mail Removed)...
> > This is what that statement looks like. PhoneNumber is the key.
> > KyleQ
> > <%
> > fp_sQry="UPDATE Results SET Name = '::Name::' , Title = '::Title::' ,
> > Organization = '::Organization::' , City = '::City::' , Zip = '::Zip::' ,
> > Email = '::Email::' , WebSite = '::WebSite::' , Affiliation =
> > '::Affiliation::' , Category = '::Category::' , ShortDesc =
> > '::ShortDesc::' ,
> > FullDesc = '::FullDesc::' , Password = '::Password::' , DateAdded =
> > ':ateAdded::' WHERE (PhoneNumber = ::PhoneNumber:"
> >
> >
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> In the page "update.asp", in Code View, you should see a statement that
> >> starts this way:
> >> fp_sQry="UPDATE
> >>
> >>
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> web: http://www.spiderwebwoman.com/resources/
> >> FrontPage Support: http://www.frontpagemvps.com/
> >>
> >>
> >>
> >>
> >> "kyleq" <(E-Mail Removed)> wrote in message
> >> news18B5CA2-5D02-4DF3-AB35-(E-Mail Removed)...
> >> > Thanks for the response Kathleen.
> >> > I don't know what "post your SQL (the UPDATE statement)?" means.
> >> > The only Post reference in the edit.asp code looks like this:
> >> >
> >> > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="50178" -->
> >> > <form
> >> > METHOD="POST" action="update.asp" onsubmit="return
> >> > FrontPage_Form1_Validator(this)" language="JavaScript"
> >> > name="FrontPage_Form1">
> >> >
> >> > It is the FrontPage generated script and I assume it cannot complete.
> >> > Kyleq
> >> >
> >> >
> >> >
> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >> >
> >> >> Can you post your SQL (the UPDATE statement)?
> >> >>
> >> >> --
> >> >>
> >> >> ~ Kathleen Anderson
> >> >> Microsoft MVP - FrontPage
> >> >> Spider Web Woman Designs
> >> >> web: http://www.spiderwebwoman.com/resources/
> >> >> FrontPage Support: http://www.frontpagemvps.com/
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "kyleq" <(E-Mail Removed)> wrote in message
> >> >> news:371ACF21-E2A0-445F-AF3E-(E-Mail Removed)...
> >> >> >I have used the DIW to add a database maintenance function to my web.
> >> >> >The
> >> >> > results will allow me to add a record, delete a record and view
> >> >> > records
> >> >> > but
> >> >> > it will not allow me to edit a record.
> >> >> > When I open a record for editing it allows me to make changes but
> >> >> > when
> >> >> > the
> >> >> > OK button is clicked the following error message pops up.
> >> >> >
> >> >> > "Database Results Wizard Error
> >> >> > Description: Syntax error in UPDATE statement.
> >> >> > Number: -2147217900 (0x80040E14)
> >> >> > Source: Microsoft JET Database Engine
> >> >> >
> >> >> > I get to this point by opening the List page and displaying the
> >> >> > record
> >> >> > set.
> >> >> > I double click on a record to open the detail page and click edit to
> >> >> > open
> >> >> > the
> >> >> > edit page. After making the changes I click the OK button and the
> >> >> > error
> >> >> > message displays.
> >> >> > Help please
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>