ADO and DAO with Access

[Druettoj]

I have a Access Database with 1 millon of records and it have 460 Mb.

1) In one project I have a dao control conect to a datagrid.
The source of dao control have a SQL like select * from table where (yearmonth = 200001).
When I run the aplication, I have a fast response from the database. The response is immediately

2) If I use a ADO control conect to a datagrid, with the same SQL, the aplication have a big delay (1 or 2 minutes)depending of the SQL.

I change some parameters from the conection of the ADO but never have a fast response from the database like a DAO control

Any Idea???

[parksie]

What open mode are you using for the ADO query?

[Druettoj]

I create a environment, use a connection with microsoft jet 4.0 OLE DB Provider.
After that I create a command with a SQL command.
In the advance parameter I use a Recordset and a cursor over the client

[parksie]

Try using a server-side cursor.

[Druettoj]

Using a server-side cursor I dont obtain any records.
When use a server-side cursor, the data grid appear in blank

Julián

[JHausmann]

Is the database on some machine other than yours? If so you could try making a database that has links to the one with data and open the one that contains the links...