Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FP2000: Unknown Field Error When Viewing Page With Database Region

FP2000: Unknown Field Error When Viewing Page With Database Region

View products that this article applies to.

This article was previously published under Q205932

For a Microsoft FrontPage 98 version of this article, see 181655� (http://support.microsoft.com/kb/181655/EN-US/ ) .

↑ Back to the top

Symptoms

When you browse to a page containing a database region, you see the following message displayed in the browser:
Database Results Error:
Description: [Microsoft][ODBC Microsoft Access 97 Driver] The INSERT INTO statement contains the following unknown field name: 'Field1'. Make sure you've typed the name correctly, and try the operation again.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers.

↑ Back to the top

Cause

This behavior occurs when the field name you specified in the INSERT INTO statement does not exist in the database being queried. This often happens if you have mistyped the query.

↑ Back to the top

Resolution

To resolve this behavior, you must specify the correct field name in the INSERT INTO statement. To do this, follow these steps:
  1. Determine the correct field name in your database.
    1. Start Microsoft Access and open your database.
    2. Select the table you are querying, and then click Design View.
    3. Note the name of the field you would like to query. The field name appears in the Field Name column.
    4. On the File menu, click Exit.
  2. Start or switch to FrontPage, and then open the page that contains the database region.
  3. Right-click any of the column values in your database region and then click Database Results Properties on the menu that appears.
  4. Click Next.
  5. Click Edit.
  6. In the INSERT INTO statement, type the name of the field you noted in step 1.

    For example, if the field name is Field1, type your query similar to the following: 
    INSERT INTO TableName (Field1) Values ('::Field1::')
    NOTE: Your query may be different depending on the name of your table and the number of fields you are querying.
  7. Click OK.
  8. Click Next three times.
  9. Click Finish.
  10. On the File menu, click Save.

↑ Back to the top

Keywords: KB205932, kbprb

↑ Back to the top

Article Info
Article ID : 205932
Revision : 1
Created on : 10/1/2001
Published on : 10/1/2001
Exists online : False
Views : 230