Solved - we've had a play about with the indexing on the table and that's sorted it (!).
Dan ________________________________ From: Dan Powderhill [mailto:[EMAIL PROTECTED] Sent: 17 January 2005 15:35 To: [email protected] Subject: [AspClassicAnyQuestionIsOk] Strange error when using GetRows() I'm getting a very strange error here. I'm loading data into a series of arrays using the GetRows method of the recordset. All works for most of the SQL statements, however one, which is very simple, is causing me grief. Basically I'm getting the same data, just ordered by different fields, so I have one SQL statement which uses one field in the order by clause (which works and returns an array with some 40,000+ records in), and an almost identical statement, the only difference being it orders by a different field. The second one fails when I call GetRows(), giving me the JET database error "Record is deleted". Both report the same number of records in RecordCount property before the GetRows() call. Anyone come across this before? I can post code if necessary, although it's all pretty standard - I haven't initially because it's split across several functions and is a little fiddly. Thanks in advance. Dan [Non-text portions of this message have been removed] ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
