We have completed a clean install of Microsoft Server 2003
on our Web Server and are using frontpage 2002 for our web
site. On our asp page (www.dgf.k12.mn.us/contactus.asp) we
are getting the following error:

Database Results Error
Description: Syntax error in query. Incomplete query
clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
www.dgf.k12.mn.us/contactus.asp

We cannot find any kind of documentation on this error.
Has anyone else seen this kind of error, and know how to
fix it?

thanks for the help


Nicole

"nicole" <nhanson@dgf.k12.mn.us> wrote in message
news:1e31001c38916$2730c7e0$a601280a@phx.gbl...[color=blue]
> We have completed a clean install of Microsoft Server 2003
> on our Web Server and are using frontpage 2002 for our web
> site. On our asp page (www.dgf.k12.mn.us/contactus.asp) we
> are getting the following error:
>
> Database Results Error
> Description: Syntax error in query. Incomplete query
> clause.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
> www.dgf.k12.mn.us/contactus.asp
>
> We cannot find any kind of documentation on this error.
> Has anyone else seen this kind of error, and know how to
> fix it?[/color]

Start here:
http://www.aspfaq.com/2400

There are a few other articles that mention 80040E14 as well ...

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

May I suggest using unique subject lines that pertain to your post instead
of just using "asp question" for all of them? We already know (or hope)
that your question will be ASP related when posted in this group.

Ray at work

"nicole" <nhanson@dgf.k12.mn.us> wrote in message
news:1e31001c38916$2730c7e0$a601280a@phx.gbl...[color=blue]
> We have completed a clean install of Microsoft Server 2003
> on our Web Server and are using frontpage 2002 for our web
> site. On our asp page (www.dgf.k12.mn.us/contactus.asp) we
> are getting the following error:
>
> Database Results Error
> Description: Syntax error in query. Incomplete query
> clause.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
> www.dgf.k12.mn.us/contactus.asp
>
> We cannot find any kind of documentation on this error.
> Has anyone else seen this kind of error, and know how to
> fix it?
>
> thanks for the help
>
>
> Nicole[/color]

You are using the fp webbots for the query. You may get more help at
microsoft.public.frontpage.client

Mike


"nicole" <nhanson@dgf.k12.mn.us> wrote in message
news:1e31001c38916$2730c7e0$a601280a@phx.gbl...[color=blue]
> We have completed a clean install of Microsoft Server 2003
> on our Web Server and are using frontpage 2002 for our web
> site. On our asp page (www.dgf.k12.mn.us/contactus.asp) we
> are getting the following error:
>
> Database Results Error
> Description: Syntax error in query. Incomplete query
> clause.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
> www.dgf.k12.mn.us/contactus.asp
>
> We cannot find any kind of documentation on this error.
> Has anyone else seen this kind of error, and know how to
> fix it?
>
> thanks for the help
>
>
> Nicole[/color]

In article <eVRf0qRiDHA.752@TK2MSFTNGP12.phx.gbl>, "Ray at <%
=sLocation%>" <myfirstname at lane34 dot com> says...

Don't listen to him, London^H^H^H^H^H^HNicole.
Everyone posting here started out as an egg and a sperm
and had to take it from there. You can post any
questions^H^H^H^H^H^H^H^H^Hsubject lines here, from total
beginner level, to total expert level.
Don't be discouraged by the idoits [sic] who post nonsense.
[color=blue]
> May I suggest using unique subject lines that pertain to your post instead
> of just using "asp question" for all of them? We already know (or hope)
> that your question will be ASP related when posted in this group.[/color]

It looks like you have hyperterminal configured wrong. :P

Ray at home

"Guinness Mann" <GMann@dublin.com> wrote in message
news:MPG.19e65c06c33b7a479896dc@news.newsguy.com.. .[color=blue]
> In article <eVRf0qRiDHA.752@TK2MSFTNGP12.phx.gbl>, "Ray at <%
> =sLocation%>" <myfirstname at lane34 dot com> says...
>
> Don't listen to him, London^H^H^H^H^H^HNicole.
> Everyone posting here started out as an egg and a sperm
> and had to take it from there. You can post any
> questions^H^H^H^H^H^H^H^H^Hsubject lines here, from total
> beginner level, to total expert level.
> Don't be discouraged by the idoits [sic] who post nonsense.
>[color=green]
> > May I suggest using unique subject lines that pertain to your post[/color][/color]
instead[color=blue][color=green]
> > of just using "asp question" for all of them? We already know (or hope)
> > that your question will be ASP related when posted in this group.[/color][/color]

i guess we better not go into whether some eggs and sperm were of wildly
differing quality.

maybe everyone else should post with a subject line of "ASP question" for
the benefit of Guiness!

Jason

"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:OsusI6UiDHA.3556@tk2msftngp13.phx.gbl...[color=blue]
> It looks like you have hyperterminal configured wrong. :P
>
> Ray at home
>
> "Guinness Mann" <GMann@dublin.com> wrote in message
> news:MPG.19e65c06c33b7a479896dc@news.newsguy.com.. .[color=green]
> > In article <eVRf0qRiDHA.752@TK2MSFTNGP12.phx.gbl>, "Ray at <%
> > =sLocation%>" <myfirstname at lane34 dot com> says...
> >
> > Don't listen to him, London^H^H^H^H^H^HNicole.
> > Everyone posting here started out as an egg and a sperm
> > and had to take it from there. You can post any
> > questions^H^H^H^H^H^H^H^H^Hsubject lines here, from total
> > beginner level, to total expert level.
> > Don't be discouraged by the idoits [sic] who post nonsense.
> >[color=darkred]
> > > May I suggest using unique subject lines that pertain to your post[/color][/color]
> instead[color=green][color=darkred]
> > > of just using "asp question" for all of them? We already know (or[/color][/color][/color]
hope)[color=blue][color=green][color=darkred]
> > > that your question will be ASP related when posted in this group.[/color][/color]
>
>[/color]

In article <eZ$rsmaiDHA.2408@TK2MSFTNGP12.phx.gbl>, jason@pinhut.com
says...[color=blue]
> maybe everyone else should post with a subject line of "ASP question" for
> the benefit of Guiness![/color]

Guinness is good for you!