You receive an "Operation failed" message in Database Results region when you preview a page in FrontPage 2003

When you preview a page in a Web browser in Microsoft Office FrontPage 2003, you may receive an error message in the Database Results region of the page. The error message may be similar to the following: This problem may occur when the page contains a search form that queries a Microsoft Office Access 2003 database.

This issue may occur in situations when empty number fields are not recognized as numbers. Therefore, a data type mismatch error occurs.

To resolve this issue, use a default value for database fields that use a numeric data type. Determine the fields that use either the Number data type or the AutoNumber data type, and then specify default values for the numeric data types that are used by the Database Results region on the page. To do so, follow these steps:

1. Identify the fields that use the Number data type or the AutoNumber data type. To do so, follow these steps:
   1. Start FrontPage, and then open your Web site.
   2. On the View menu, click Folders.
   3. Under Folder List, double-click the Fpdb folder, and then double-click the Access 2003 database file (.mdb) that you are using with your query.
   4. In Access 2003, click the table or the query that is the source of data for the search form, and then click Design.
      
      Make a note of the names of the fields that use the Number data type or the AutoNumber data type.
   5. Close the .mdb file, and then quit Access 2003.
2. Specify a default value for the numeric data types. To do so, follow these steps:
   1. Open the Web page that contains the Database Results region.
   2. Right-click the Database Results region on the page, and then click Database Results Properties.
      
      The Database Results Wizard starts.
   3. Click Next, and then click Next.
   4. Click More Options.
   5. In the More Options dialog box, click Defaults.
   6. Click a field that uses the Number data type or the AutoNumber data type, and then click Edit.
   7. In the Value box, type a default numeric value, and then click OK. For example, type 0 (zero).
   8. Repeat steps 2f and 2g for each field that uses the Number data type or the AutoNumber data type.
   9. Click OK, and then click OK.
   10. Click Next, click Next, and then click Finish.
   11. On the File menu, click Save.
   12. On the File menu, click Preview in Browser.

For more information about FrontPage, visit the following Microsoft Web site: