database error help

[Paul Milner]

I have made a search form with the results wizard
The fields to search are
Sponsorship_amount (criteria comparison= Contains)
Sponsorship type (criteria comparison= Not greater than)
both or/and are set at OR

The fields are in this order on the form. if I enter a
value into the top(Sponsorship_amount) field the search
works even with nothing in the bottom field but if I
leave out the top field it returns an error

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

How can I get my search to work if either field is
entered
Thankyou
Paul M

 

[Kathleen Anderson [MVP - FrontPage]]

What version of FrontPage?

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Paul Milner]

Hi
Version 2003 although I notices that the access database
that FP created is 2000 format

 

[Kathleen Anderson [MVP - FrontPage]]

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True

 

[Paul Milner]

How do I open the hidden folder /_fpclass/, where is it
Paul M

 

[Kathleen Anderson [MVP - FrontPage]]

Tools | Web Settings | Advanced | Options - the checkbox for 'Show documents
in hidden directories' needs to be checked.