FP98: Error Browsing Active Server Page if Form Field Empty This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
This article was previously published under Q175170 SYMPTOMS
When you browse an Active Server Page (ASP), you receive the following error message in the
Database Region Wizard:
Database Error: [Microsoft] [ODBC Microsoft Access 97 Driver]
NOTE: The error message you receive will vary depending on which ODBC driver you are using.
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. One or more form fields were empty. CAUSE
This error appears if your SQL statement uses a parameter field that is
populated by form data, but the form field that generates this data is
unpopulated.
RESOLUTION
To resolve this problem, ensure that your form fields have been filled in
before the query is submitted. To do this, use form field validation to
require that the form field be filled in before it is submitted.
For more information about validating form fields, click the Index tab in FrontPage Help, type the following text
forms, validating text box fields
and then double-click the selected text to go to the "To validate a text box field" topic.
REFERENCES
For more information about the Database Region Wizard, click the Index tab in FrontPage Help,
type the following text
Database Region Wizard, overview
and then double-click the selected text to go to the "Database Region Wizard" topic.
For more information about using ODBC data source files, please see the following article in the Microsoft Knowledge Base: 161155 (http://support.microsoft.com/kb/161155/EN-US/) FP97: How to Make a Web Page Display Data from a Database
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Help and Support
Back to the top
|
