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???