ASP "getRows" error

[liz0001]

I have an MSAccess database that is updated by multiple users. I am searching for particular records. Sometimes the search works, and sometimes it errors out. I have been at this for a long time and I just can't figure it out. Does anyone have any suggestions? Here is my code:

___
sqlSearchQuery = "SELECT DishID, DishName, TypeID, UserID, RecipeText FROM Recipe WHERE DishName LIKE '%" & SearchTerm & "%' AND Private = False ORDER BY RecipeText, UserID ASC;"
Set SearchRS = Server.CreateOb ject("ADODB.Rec ordset")
SearchRS.Open sqlSearchQuery, conn, 3, 3

IF SearchRS.EOF = "True" THEN
SearchRS.close
set SearchRS = Nothing
NoResponses = "Yes"
'No dishes with 'SearchTerm' in the title.
ELSE

SearchArray = SearchRS.getRow s()

SearchRS.close
set SearchRS = nothing
END IF
___

The error happens at SearchArray = SearchRS.getRow s(), and it shows:

___
Microsoft JET Database Engine error '80004005'

Record is deleted.

/RecipeSearchFra me.asp, line 88
___

I don't know how the record could be deleted if I'm just calling it up right at that point (I made sure no one else was using the database at the same time.)

[CroCrew]

Give this a try~

<%
    sqlSearchQuery = "SELECT DishID, DishName, TypeID, UserID, RecipeText FROM Recipe WHERE DishName LIKE '%" & SearchTerm & "%' AND Private = False ORDER BY RecipeText, UserID ASC;"
 
    Set adoCon = Server.CreateObject("ADODB.Connection")
    adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Relative path to your Access database") 
 
    Set SearchRS = Server.CreateObject("ADODB.Recordset") 
    SearchRS.Open sqlSearchQuery, adoCon
 
    If (SearchRS.EOF) Then
        NoResponses = "Yes"
    Else
        SearchArray = SearchRS.getRows(SearchRS.RecordCount, 0)
    End If
 
    SearchRS.close
    set SearchRS = nothing
%>
 
 

[liz0001]

Thank you for the quick response! However, I still get the same error.

I forgot to mention that it works without errors if nothing is found in the database. The error comes only sometimes when the search DOES pull responses from the database. I can do a SearchRS.record count instead of the getrows() without getting an error.

[CroCrew]

Take a look at this:

http://tutorials.aspfa q.com/8000xxxxx-errors/80004005-errors.html

It seems to have a few examples to try out to fix your problem.

Hope that it helps~

[liz0001]

Thanks for the help. It appears that some of my data had been corrupted and that was what caused the error.