Help and Support

"Database Results Error" error message when you preview a page in FrontPage 2002

View products that this article applies to.
Article ID:299911
Last Review:January 31, 2007
Revision:2.2
This article was previously published under Q299911
For a Microsoft FrontPage 2000 version of this article, see 265320 (http://support.microsoft.com/kb/265320/EN-US/).

SYMPTOMS

When you preview a page in a Web browser, you receive an error message similar to the following:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(EmployeeID = AND FirstName = '')'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.
The error message appears in the Database Results region of a page containing a search form that queries the database by using selected criteria.

Back to the top

CAUSE

This problem occurs because empty number fields are not recognized as numbers and result in a data type mismatch error.

Back to the top

RESOLUTION

To have the page appear without the error described in the "Symptoms" section of this article, use a default value for any database field that has a numeric data type. First determine which fields have Number or AutoNumber data types, and then specify default values for the numeric data types used by the Database Results region. To do this, follow these steps:
1.Identify the fields that have Number or AutoNumber data types:
a. In FrontPage, click Folders on the View menu. In the Folder list, double-click the Fpdb folder to open it. Double-click the Microsoft Access database file that you are using with your query.
b. In Access, highlight the table or query that is the source of data for the search form, and then click Design.
c. Note the names of any fields that have a data type of Number or AutoNumber.
d. Close the file and quit Access.
2.Specify a default value for the numeric data types:
a. In FrontPage, right-click the Database Results region, and then click Database Results Properties on the menu that appears.

The Database Results Wizard starts.
b. Click Next two times.

You should be at the third step in the Wizard.
c. Click More Options. In the More Options dialog box, click Defaults.
d. Select a field that has the Number or AutoNumber data type and click Edit.
e. In the Value box, type a default numeric value. For example, type 0 (zero), and then click OK.
f. Repeat steps d and e for each field that has a Number or AutoNumber data type.
g. Click OK twice to return to the third step in the wizard.
h. Click Next twice, and then click Finish.
3.On the File menu, click Save.
4.On the File menu, click Preview in Browser.

Back to the top

MORE INFORMATION

For additional information about working with FrontPage and Access data types, click the article number below to view the article in the Microsoft Knowledge Base:
284843 (http://support.microsoft.com/kb/284843/EN-US/) FP2002: Error Querying Date/Time Fields in Access Database
265176 (http://support.microsoft.com/kb/265176/EN-US/) FP2000: Microsoft Access 2000 Hyperlink Fields Are Displayed As URLs Rather Than Descriptive Text

Back to the top

APPLIES TO
•Microsoft FrontPage 2002 Standard Edition

Back to the top

Keywords: 
kberrmsg kbopenfile kbprb KB299911

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.