Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 898752 - Last Review: October 23, 2006 - Revision: 1.4
The FrontPage Web site can no longer query the database, and you may receive the "Syntax error in query" error message
You change a Microsoft FrontPage Web site that contains a database Web page. When you save the Front Page Web site to a server that is running Microsoft Windows Server, the FrontPage Web site can no longer query the database. Additionally, you may receive the following error message on the database Web page:
Database Results Wizard Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
This issue may occur if either of the following conditions are true:
- A space character is included in a query name or in a database table name that appears in the HTML code on the database Web page.
- A space character is included in a query name or in a database table name that appears in the database.
To work around this issue, use one of the following methods.
Method 1: Use the Database Results Wizard
Use the Database Results Wizard to define the query name or the database table name that contains a space character. To do this, follow these steps:
- Open the database Web page in FrontPage.
- Double-click the Database Results area to start the Database Results Wizard, and then click OK.
- Click Next.
- Click Custom query, and then click Edit.
- In the SQL statement box, type square brackets ([ ]) around the query name or around the database table name that contains the space character.
For example, the SQL statement should look similar to the following statement: SELECT * FROM [My Table]
- Click OK.
- Click Next, and then complete the Database Results Wizard.
- Save the database Web page, and then republish it.
Method 2: Change the query name or the database table name
- In the HTML code of the database Web page, change the query name or the database table name to a name that does not include a space character. For example, change "My Query" to "My_Query".
- In the database, change the query name or the database table name to the same name that you used in the HTML code of the database Web page.
- Save the database Web page, and then republish it.
APPLIES TO
- Microsoft Office FrontPage 2003
- Microsoft FrontPage 2002 Standard Edition
- Microsoft FrontPage 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate