Assync Recordset with ADO Data Control

[Pedro Gonçalves]

I have one table in SQL Server with 980.000 records and I used a DAO data
control linked to a grid to display that information. With this select 'Select
Id, Title From books', that data control showed same information in a second,
of course if I scroll the grid I had to wait...
Now, I using ADO Data Control, but that same select stop the application
till it has all records from that table, I mean, 2-3 minutes to show samething...
These any body know any method to do the same thing DAO did?
Thanks!

[Jeff Binnig]

ado data control does not support async record fetching.
ado recordset's do to some extent. using withevents when you dim an ado rs
will allow you to use the
async features.
--
-----------------------------------------------------------
Chemical Information Services, Inc.
Mailing Address: P.O. Box 743512 Dallas, TX U.S.A 75374
Corporate Offices: 9550 Forest Lane, Suite 321 Dallas, TX U.S.A. 75243
Tel: 214-349-6200 Ext. 106 Fax: 214-349-6286
www.chemicalinfo.com
Pedro Gonçalves <pedrog@marque.pt> wrote in message
news:395e3384$1@news.devx.com...
>
> I have one table in SQL Server with 980.000 records and I used a DAO data
> control linked to a grid to display that information. With this select
'Select
> Id, Title From books', that data control showed same information in a
second,
> of course if I scroll the grid I had to wait...
> Now, I using ADO Data Control, but that same select stop the application
> till it has all records from that table, I mean, 2-3 minutes to show
samething...
> These any body know any method to do the same thing DAO did?
> Thanks!
>