ADO Recordsets

[TheBionicOrange]

I am accessing a file using ADO. My recrod collection that is returned is large.
The first thing I do is check that I actually have any records, if not then bomb the user out.

The problem I am finding is that when you have a large record collection returned, if you check the recordcount or see whether .EOF = TRUE, it takes AGES to work it out, therefore delaying the flow of my program, and consequently annoying the hell out of the user as they have to sit and wait !!

Is there a way of checking that you have some records returned without having to forego this lengthy wait whilst the program sorts its life out ?

I hope I have explained myself well enough. I caqn supply code if required.

Thanks

Steve.

p.s. I know I posted this question under 'General questions', but I get a quicker response that way

[vbgladiator]

I think that the eof or bof are set as soon as you open your recordset so I doubt that they cause the delay. Post your code if you can.

[FATBOYPEE]

Check the RecordCount property. It wil lreturn 0 if no records found, -1 if there are records, not how many.

FBP