extra time in opening a recordset

[Shahzad]

guys, when i bind a Microsoft Access database to my vc program, it takes quite considerable time (about 2 or 3 seconds) when the recordset is opened for the first time. I don't understand why this much delay occurs? I have P166 machine, is it slow or what is the matter?

[suri]

Just a suggestion. U can use a very intelligent SQL query as per U'r requirement instead of opening the whole table. I guess it would be faster as the whole table would not be used. More so if the table contains large data.