Microsoft KB Archive/891819

= You cannot update a database by using the Web pages that were created by the Database Interface Wizard in FrontPage 2003 =

Article ID: 891819

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Office FrontPage 2003

-



SYMPTOMS
When you create Web pages by using the Database Interface Wizard in Microsoft Office FrontPage 2003, you may experience one or more of the following symptoms:  You cannot update the database by using the Web pages that were created by the Database Interface Wizard. You may receive one or more of the following error messages:

Database Results Wizard Error

The operation failed. If this continues, please contact your server administrator.

Database Results Wizard Error

Description: Syntax error in query. Incomplete query clause.

Number: -2147217900 (0x80040E14)

Source: Microsoft JET Database Engine





CAUSE
This issue occurs because some tables in the database have names that contain blank spaces. The Database Interface Wizard in FrontPage 2003 does not support blank spaces in database table names.



WORKAROUND
To work around this issue, use one of the following methods.

Method 1: Use the Database Results Wizard to change the default SQL query for database tables
 Open the Front Page 2003 application that contains the Web pages that you created by using the Database Results Wizard. On the Insert menu, click Database, and then click Results to start the Database Results Wizard. Select the appropriate options on the first page of the wizard, and then click Next. Click Custom Query, and then click Edit.</li> A query string that is similar to following appears:

SELECT * FROM &quot;table name&quot;

Change the query string by replacing the quotation marks with brackets so that the query string appears similar to the following:

SELECT * FROM [table name]

</li> Click Next, and then follow the instructions that appear on the screen to complete the steps in the wizard.</li></ol>

Method 2: Remove the blank spaces from the table names in the database

 * 1) In the database, change every table name that contains blank spaces to a name that does not contain blank spaces.
 * 2) Start the Database Interface Wizard to create new Web pages that update the database by using the new table names.

Additional query words: FP2003

Keywords: kbforms kbdatabase kbasp kberrmsg kbtshoot kbprb KB891819

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.