I have a query that selects rows from an Access2K database.  I had the sql 
response.write to the page.  Then I pasted the sql in an Access query, and 
it worked and returned rows.

But when I run code to populate a table on the page, I get the error 
message: 

ADODB.Recordset error '800a0bcd' 

Either BOF or EOF is True, or the current record has been deleted. 
Requested operation requires a current record. 

The page is a search function letting users search the database.
The users select an option from a list box, then can type keywords into 
either of 2 text boxes.  My code is checks the len of these boxes, and if 
the len > 0, it concatenates the keyword they've typed into the sql.

Like I said, the sql is being response.write to the page, so I know it's 
concatenating them correctly.

Any ideas?

thanks!

Just an update - I had recordset.recordcount written to the page.  The 
number of records is -1.  

Can you please post the SQL statement you are using?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Dennis Stevens" <bastnakt@y...>
Subject: [access_asp] Not returning rows


: I have a query that selects rows from an Access2K database.  I had the sql
: response.write to the page.  Then I pasted the sql in an Access query, and
: it worked and returned rows.
:
: But when I run code to populate a table on the page, I get the error
: message:
:
: ADODB.Recordset error '800a0bcd'
:
: Either BOF or EOF is True, or the current record has been deleted.
: Requested operation requires a current record.
:
: The page is a search function letting users search the database.
: The users select an option from a list box, then can type keywords into
: either of 2 text boxes.  My code is checks the len of these boxes, and if
: the len > 0, it concatenates the keyword they've typed into the sql.
:
: Like I said, the sql is being response.write to the page, so I know it's
: concatenating them correctly.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~