database error - form field empty

From: MTF (MTF_at_discussions.microsoft.com)
Date: 03/25/05


Date: Fri, 25 Mar 2005 08:41:04 -0800

I am getting intermittent errors with a Front Page ASP form making a database
inquiry. The really frustrating part is that it happens some days and not
other days with the same forms! There is usually only one form field on the
page - the rest is all database results. The files that are being queried are
DBF files, and there are no empty fields in the table - I've triple checked
that.

The only real clue in the error message, pasted in below is the empty form
field and the need for a default value, but I can't seem to find a way to put
in a default value.

All help greatly appreciated!

Error message:
Database Results Error
Description: [Microsoft][ODBC dBase Driver] System resource exceeded.
Number: -2147024882 (0x8007000E)
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.



Relevant Pages

  • Re: Database Wizard P*****G me off
    ... Microsoft Office FrontPage ... > In the SQL language, which the DRW uses to perform database operations, as ... Syntax error in UPDATE statement. ... >> One or more form fields were empty. ...
    (microsoft.public.frontpage.programming)
  • Re: Insert txt files into a form?
    ... I figured out a way to set up the data in word using form fields from my ... but each entry sets up on it's own "page." ... I am using a database program to maintain research articles records. ... word wher ethe form fields are lined up as a bibliography. ...
    (microsoft.public.word.docmanagement)
  • Re: Locking form
    ... you could have the data from your form fields ... uploaded to a database, ... >> original plus the pdf. ... >> This message is posted to a newsgroup. ...
    (microsoft.public.word.vba.general)
  • re: Multi page forms
    ... Personal info on first page, ... Save all the submitted form fields in Session ... Copy this information into the database only when the ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Re: Search an Access Database
    ... RJP wrote: ... > Source: Microsoft JET Database Engine ... > for all form fields that are used in the query. ... >>> Spider Web Woman Designs ...
    (microsoft.public.frontpage.programming)

Loading