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.