MainQuery = "Select * From [Create_Modify_User$] where F1 = '"&TCNumber&"' and F2 ='"&TCIteration&"' and F3 ='"&TCRecordIdentity&"' "
MainRecSet.Open MainQuery, oConn,3,3,1
It is waiting for a long time in the line MainRecSet.RecordCount though the query will return only 2 records. This happens for few sheets alone. Kindly Advice.