Problem in CRecordset::Open.

Hi all,

i m using Access databse and ODBC connection to connectivity with the database.
there is number of tabels approx 36 tabels.

Each n every table have separate CRecordset derived class.

at one point when i m using many of these table,firstly its working fine but after some time
CRecordset::Open takes so much time to open recordset and between this duration application looks like not responding.

please help me how can i resolve this.

please help for this.

thanks in advance.

No telling what's going on. If your query returns a lot of records, try using a dynaset instead of a snapshot.

I m already using dynaset.

If the database fetch operation takes a while and you are doing it in the main UI thread, it's going to make the app non-responsive.

To fix this, put the database operation into a secondary thread.