<div>
Can you post the offending code?
</div>


<div>
Try rebuilding it with FP. &nbsp;Sometimes the coding is corrupt &amp;&nbsp;re0building usually fixes the problem.<br />
<br />
-Corey<br />

</div>


Try rebuilding it with FP.  Sometimes the coding is corrupt & re0building usually fixes the problem.

-Corey


<div>
Hi,<br />
<br />
It is better if you can post the code.<br />
<br />
I guess that you have additional quotations in your query. &nbsp;Take a look at the query and balance the quotation marks.<br />
<br />
hhammash
</div>


Hi,

It is better if you can post the code.

I guess that you have additional quotations in your query.  Take a look at the query and balance the quotation marks.

hhammash

<div>
Instead of using the Access query, I created the same custom query with the Frontpage DRW as the link suggests.<br />
<br />
Thanks,<br />
Great Work!
</div>


Instead of using the Access query, I created the same custom query with the Frontpage DRW as the link suggests.

Thanks,
Great Work!

<div>
<div class="content wysiwyg-content">
I just installed a new server with Windows 2003 Server and IIS 6.0 and Frontpage 2003 and Frontpage 2002 Extensions.<br />
<br />
I am using .asp to query a database of employee contact information and get back the following error for any query:<br />
<br />
Database Results Error<br />
Description: Syntax error in query. Incomplete query clause.<br />
Number: -2147217900 (0x80040E14)<br />
Source: Microsoft JET Database Engine<br />
<br />
I have another database on the website that gets no errors when querying it. So I am confused why this database hase a problem.
</div>
</div>


I just installed a new server with Windows 2003 Server and IIS 6.0 and Frontpage 2003 and Frontpage 2002 Extensions.

I am using .asp to query a database of employee contact information and get back the following error for any query:

Database Results Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

I have another database on the website that gets no errors when querying it. So I am confused why this database hase a problem.

Database Results Error - Syntax error in query. Incomplete query clause.

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.